Requery Form

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I'm closing a form. when this happens I want to Requery another form
that has no connection to this form, How do you do this?

Forms!Main.Requery

This doesn't work.
Thanks
DS
 
DS said:
I'm closing a form. when this happens I want to Requery another form that
has no connection to this form, How do you do this?

Forms!Main.Requery
Click to expand...


Hum, the above syntax looks ok. Is the name of the form you want to requery
called "main". If yes, then in the close event of your form, you can put the
code:


forms!NameOfYourFormToRequery.Requery

And, in your example, we have to assume a form named "main", so, we get:

Forms!Main.Requery

If you are not receiving any error message, then perhaps the code is running
correctly. If the above command was not working, you should get some type of
error message.
 
Hi DS,

I am trying to understand this stuff. What does requerying another form do
for you when you are closing out a form?

Thanks,
Linda
 
Back
Top