Refresh main form after activities in the subform 1

[mtabt]

I have a command button in the subform of main form to bring up another form (form1) to enter data. After the form1 is closed, I need to refresh the main form and subform to reflect the changes. I tried the normal way such as

*DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

*DoCmd.requery
etc.

But, nothing works.

However, if the command button is located in the main form, everything is ok.

Therefore, my question is how to focus and refresh the main form after I click on this command button in the subform?

Thank you very much

 

[LonnieJohnson]

On the data entry form's Close Event try this:

Forms![MainFormNameHere].Requery
Forms![MainFormNameHere].Refresh

Hope this helps. ljprodev@yahoo.com
Professional Development
MS Access Applications