What event to host a subform Requery statement

D

Dean Slindee

Access 2002 adp project: with subforms shown on tabcontrol pages:

The main form displays a tabcontrol where the first tab hosts data fields
for the parent table.

Subsequent tabpages host subforms for child tables.

I need to be able to issue a Me.Requery event when leaving each subform and
want to know where to site the statement so that it always fires, no matter
how the subform is left.

The reason I need to do this (or something like it) is so that when the user
uses the mouse to click on a subform tabpage that was previously entered,
that the data that was entered is reshown on the subform. If I don't issue
a Me.Requery, the subform is blank (even though the database is correct).

How can I force an event to happen that contains a Me.Requery for that form?

Thanks,

Dean Slindee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top