automatic updates on forms. Explanation

[Lifeseeker]

Hi,

When two forms are open, would it be possible to reflect the changes made on the other?

I have noticed that users do not want to close the current right after updates are put in. They just want to see if the change has been recorded on another form.

So an example would be......a user is doing updates on this primary form. At the same time, another datasheet form is opened in another tab as well.

Every time a change is made through the datasheet form(changing numbers, etc, the change won't automatically get reflect on the primary form unless the refresh button is clicked on the primary form.

Users might think that this is an error. How should I explain to them or how should I try to avoid "hitting refresh" every time they want to see changes made on the other form?


any thought/comment much appreciated.

 

[John Big Booty]

As part of the update procedure you could force the underlying master form to re-query whenever a change is made on the pop up form, using;

Forms!YourMasterFormName.Requery