fmmcmillan said:
how to requery an entire form when a field changes
What do you mean by the word "field"?
If you mean a **control** where users enter a value then use
Me.Requery
in the control's AfterUpdate event procedure.
If you mean a **field** in the form's record source
table/query, it's difficult to tell if the field has a
different value from one record to another. In this case
it's best to ignore the possibility that the previously
viewed record might have the same value as the current
record and just use the form's Current event. However, in
this case requeryomg the form would be counter productive.
