Subform not refreshing...
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 |
Subform not refreshing...
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. |
All times are GMT +1. The time now is 03:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com