Refresh a Form 1

[paulbradley]

Is it possible to refresh a form? I have a form showing continuous records with an 'Add Record' button. I would like an event procedure OnClose of this form to refresh or reload the form behind. Any better ideas than just closing the form and opeing it again?

Thanks in advance.

 

[Nowell]

Hi there

you can used a requery command, but do not know why you want it on the onclose event, and what do you mean by the form behind?

 

[nerdcore]

You can use the following line of VBA Code to refresh the record set for the main form (insert your form name of course)

Forms![your_main_form].Requery

I am using this right after a Docmd.Close statement, however it should work fine in the OnClose event.