Refreshing

[gselliott]

Is it possible to refresh or requery a form that is currently open after another form is closed?

Basically what i need is when i close one of my forms down i would like the data from this form to update automatically in the main form (which is allready running in the background). At the moment i am having to close both forms then reopen the main form before the new data is updated.

Can this be done using a refresh or requery somewhere in the code?

Hope someone can help.

Thanks

 

[IMO]

In the OnClose event of your second form..

Forms!frmYourMainForm.Refresh

IMO

 

[gselliott]

Thanks very much worked a treat, although i had to use .Requery instead of .Refresh.

Thanks again!