Access 2002 - Update parent form when child form data changes

Vote count:

0

I have two forms (FormA, and FormB say). I have an address that is displayed on FormA. If the address is no longer valid (mail returned as unknown at that address) the address is displayed on FormA in red.

FormB allows me to update the information displayed on FormA. I have a radio button on FormB that updates status of the address: on for not valid, off for valid. When I click the radio button to "on" (address invalid) on FormB and close FromB, focus returns to FormA. I want the change I made on FormB to be reflected in FormA. That is, if the address is marked as "valid" on FormA, and I want to change it to "invalid" using the control on FormB, I want FormA to refresh the colour of the text to reflect the fresh data.

How do I do this please? I have tried

   Me!contactAddress.requery

in the {Form_GotFocus} section of FormA, but this does not work.

asked 37 secs ago

Steve Cooke

56