I have a main Navigation form for my User Interface. In this main form, there is a command button for adding new events to the events table. I have a Query that shows only events that will happen within a specific time frame. Then back on my main Navigation form, there is a subform that shows Upcoming Events from the Events Query. What I need is a Macro that upon the closing of the form for entering new events, the subform will be updated to include the new event. Can anyone help me?