Query-based form not repainting

[lscheer]

I have a form (Form2) that I am updating some data on based on info from another form (Form1). I have set up a macro that updates all the necessary information (ID, contact info, etc.) into Form2 by opening Form2 and using SetValue to set the ID number to match the ID from Form1. This all works fine and dandy, and the rest of the data is there, but isn't displayed until I close then re-open the form, or use ShowAllRecords. Shift+F9 works to refresh the form, but a Refresh, Requery or Repaint macro doesn't do the trick. Any suggestions on making this work a little better? (i.e. immediate display of all the data, along with ID)??? Thanks!

 

[robearle]

Go
Tools -> Options -> Advanced -> Then change the refresh interval to something like 1 second

rob