S
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
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