Okay, I have a main navigation form that contains a subform based off a query that shows upcoming events. On my main navigation form I can open a data entry form to add new events. I need to use a macro upon closing the data entry form for new events that refreshes the query and subform based off that query so that the new event shows up in my subform.
So far, I have tried macros on the data entry close that run command - refresh and requery both the query and subform. If I close the main Navigation form and re-open it, the new event will appear, but not until I close and re-open. Anybody have any ideas?
So far, I have tried macros on the data entry close that run command - refresh and requery both the query and subform. If I close the main Navigation form and re-open it, the new event will appear, but not until I close and re-open. Anybody have any ideas?
