OpenForm based on query not displaying all info

[lscheer]

I have a form "Contacts" that is my master form, into which all major data entry occurs. Then I'd like to query the "Contacts" table and another table of supplemental data "Job History" to display on another form "Participants." To avoid re-entering all the contact info previously keyed in, I designed a macro to 1)Save Contacts, 2)OpenForm Participants, 3)GoToRecord New, and 4)SetValue of ParticipantID to = Contact ID. The Participants form (remember, based on the query) properly does all of the above, but does not display any of the data from the Contacts table until after the form is closed and then re-opened. Is it possible to achieve this (displaying all the data from the Contacts table) without adding a Close and Open action to my macro? Thanks!

 

[AlanS]

Use the form's Requery method.

 

[lscheer]

Thanks, but I have tried to add Requery, Refresh and Repaint as the final action in my Macro above, and none work. If I hit Shift+F9 (to refresh the form), that does it (after refreshing the form, it goes back to the first record, and ideally, I'd like it to go back to the last), but don't want to have users know/remember to hit Shift+F9. Supposedly (according to Access Help) Shift+F9 is the same as the Requery Action, but it doesn't work, I've even tried using the Requery action attached to the ID field's before and after update events. Any other suggestions???

 

[AlanS]

I'm not sure about this. The only things that occur to me are:

1. check that it is the entire form that is being requeried, and not just one of its controls; and

2. check that the contract record has been saved before the requery is executed; otherwise the requery will return the same old data.

Good luck.

 

[lscheer]

1. Check
2. Check

...still no luck!