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

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.