Refresh Form Data

[Ryan Langton]

I have a form that most users will leave open 90% of the time. Is there any
way to refresh the form automatically every minute or so without using a
user-initiated event?

 

[Rick Brandt]

I have a form that most users will leave open 90% of the time. Is
there any way to refresh the form automatically every minute or so
without using a user-initiated event?

Use the Timer event and code to either Refresh or Requery the form.

Me.Refresh
or
Me.Requery

Caveats:
Refresh will show changes to existing records in the Form's RecordSet. It
will not show new records that were added since the form was opened. The
form will stay on the same record.

Requery will pick up all changes, deletions, and additions, but the form
will revert to the first record every time the Requery is issued.