How to refresh data in forms in multi-user environment

[Amit]

Access 2K, Windows XP
-----------------------
Hi,

I've an Access database on the network which is being used
by more than one person, sometimes simultaneously.

In the Options, Advanced tab, I have:
-"Enable DDE requests" box checked
-refresh interval = 60 seconds
-number of update retries = 2
-default open mode = shared
-default records locking = edited records
-"Open database using record-level locking" box checked

The problem I'm having is that if 2 copies of the database
are open, and if user_1 enters new records which are
displayed on formA, they don't show up in the formA for
user_2 unless s/he closes the form and opens it again, or
if it is refreshed/requeried. There is a subform on formA
that lists the existing records.

Is there any way to refresh this list/subform on user_2's
screen when user_1 adds new data, without the user_2
having to close the form and reopen it.

I'm not an expert on MS Access, so if I'm missing
something here, please do point it out to me. Any help is
appreciated.

Thanks!

-Amit

 

[Albert D. Kallal]

The dde requests has nothing to do with your problem.

DDE requests refers to automation, or inter-program commutation. Certainly
nothing to do with your problem.

Is there any way to refresh this list/subform on user_2's
screen when user_1 adds new data, without the user_2
having to close the form and reopen it.

If you put a buttion on the form, and the code behind the butttion is

me.Requery

The requery metheod will re-load the form.