Requery Form

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
 
K

KARL

In the properties of the form set "On Close" to use a
macro or expression you build.
 
A

Albert D. Kallal

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.
 
L

LMB

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
 
Top