Subform not refreshing...

[Serendipity]

Here is what I have:
1) I have a main form called frmInspectionReport_AddNew with a subform
called frmItemsChosen.
2) The subform is from a query called qryItemsChosen.
3) The subform is on a tab control page.

The information that the query retrieves is based on items entered on the
previous tab control page (there is 3 tabs) as additional information needs
to be entered. The only way I can get the subform to display the information
entered is to go to design view and back to form view.

I have tried macros to refresh the query, close and open the form, etc with
no luck. What am I doing wrong? How do I get the information to display
without going to the design view? I would like the information to
automatically display when you click on the tab control rather than
displaying a blank subform.

Any help is greatly appreciated.
Kenirae

 

[NoodNutt]

G'Day Kenirae

Think your in the wrong NG.

This NG deals with Excel issues, your question sounds more like an MSAccess
one.

try this NG instead.

microsoft.public.access.formscoding

HTH
Mark.