Requery Help

[unit213]

Here's my situation. I have two separate forms...Form1 and Form2.
I have a command button on Form1 that runs a macro. When I push that button, I want
Form2 to requery. How would I go about doing that?

Thanks!

Dan

 

[unit213]

Any input? I don't seem to have any trouble getting a subform to refresh (via requery), but
I haven't been successful in telling another form to requery.

 

[strive4peace]

Hi Dan,

   with forms!formname
      'save record if changes have been made
      if .dirty then .dirty = false
      .requery
   end with
   DoEvents

~~~ DoEvents ~~~

DoEvents is used to make VBA pay attention to what is currently happening and look to see if the OS (Operating System) has any requests -- including the keyboard or noticing that a file has been deleted or created

ie: if you have a loop and want to be able to BREAK it with CTRL-BREAK, put DoEvents into the loop

DoEvents will also update values written to a form by a general procedure or code behind another form or report

A DoEvents is done when you use MsgBox, or are stepping through code (since it has to pay attention to the keyboard)

It is a good way to say, "Wake Up!"