Requery Form

Requery Form

Post by DS » Thu, 05 May 2005 07:37:48


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
 
 
 

Requery Form

Post by KARL » Thu, 05 May 2005 08:41:02

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

 
 
 

Requery Form

Post by Albert D. » Thu, 05 May 2005 09:34:26


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.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
XXXX@XXXXX.COM
http://www.yqcomputer.com/
 
 
 

Requery Form

Post by LMB » Thu, 05 May 2005 11:51:35

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