Requery unrelated form when another form closes

[BCJourney]

I have an unbound main form [main1] with a combo box, subform [subcount], and a button. The [subcount] displays a count of records for a query [30_day_qry] based on the selection in the combo box. When the button is clicked it opens a form [data_entry] that displays the results of the same query [30_day_qry] and contains a subform [input] for user input that gets saved to a table. After entering data the save button is clicked then the exit button. The form closes and you are back to the main form.

Everything works fine except that once records are changed in the subform [input], the count of records for that query usually changes. But that count doesn't change in the subform [subcount] on the main form [main1] after that query form [data_entry] is closed. I have to select another item from the drop down list to requery the suboform [subcount] or close the main form [main1] and re-open it to make the counts correct again.

I've tried to do requery in the on close event of the query form [data_entry] but nothing seems to work. I noticed that user input probably isn't saving to the table until the form is closed.

I know it sounds confusing, any help is appreciated.

[June7]

The requery code in close event should work. However, can put the code on [main1] instead. Open the [data_entry] in Dialog mode. This will suspend code execution in [main1] until [data_entry] is closed.

DoCmd.OpenForm "data_entry", , , , , acDialog
Me.subcount.Requery

[BCJourney]

You are a genius! I can't thank you enough.