Syncronizing Forms

[Chaplain Doug]

I have a tab control with mutiple pages. On page one I
enter people to be interviewed. On page 2 I enter the
results of the interview. Both pages have subforms which
query the same table for info. Thus, if enter a person to
be interviewed on page one, they should show up on page
2. At present I can enter the name to be interviewed on
page 1, but they do no show up on page 2 unless I exit the
whole form and then bring it back up. Now the question:

How do I syncronize the pages (subforms) on my tab control
so that when I enter new data on one page it shows up on
the other pages when I select them? Thanks and God bless.

 

[Joe Fallon]

Try calling a requery on the subform source query.
(at whatever moment suits your needs best. Form Open?, Form Activate?)

 

[Chaplain Doug]

Thanks. I kindof sortof thought of that after I posted.
What are we doing programming databases on Sunday anyway?!

 

[Chaplain Doug]

What worked was setting the subform control event "On
Enter" to run the code:

[subform control name].Requery

Thanks