synchronizing forms

[Sarah]

I have 3 forms that are bound to the same query. At any given time any or
all of them can be displayed on the screen. When I make a change in one of
the forms, I would like that change to be immediately reflected in the
others. I currently use Me.Requery in the forms On Activate event, so the
changes in one form don't show in the others until I click on them. How can
I synchronize these immediately?

help appreciated

 

[Damian S]

Hi Sarah,

They should update almost immediately after the record has been saved. Of
course, if you haven't saved the record, the database tables don't know about
it therefore your other forms aren't being updated.

Damian.