Updating a Subform

[kbreiss]

I have a multiuser database that is used to schedule appointments. Once in the main Form, the users select a facility from a drop down box and the suborm shows dates and times that are already filled. Their concern is if they are all in that main Form and somebody schedules an appointment, the other users do not see that change in the subform until they go out of the main form and come back into it.

...is there a way to set it up so when somebody schedules an appointment it updates everybodies subform instantaneously?

Hope this makes since.

Thanks in advance,
Kacy
________
Creampie Mature

 

[Poot]

Possibly?

I'm not entirely sure since I am relativily new to Access but...

me.requery

....might me along the lines of what you are looking for. Sure this will work in a multiuser environment.. though...well....

 

[kbreiss]

Thanks for responding....I tried the me.requery, but still not the results I am looking for. What I'm looking for is a fix if two people are viewing the same form from two different locations and one user makes an update, I would like for the screen on the other users form to be updated as well.

Thanks in advance,

Kacy
________
NEW MEXICO MEDICAL MARIJUANA