Multi User Form

A

Adonna

Good Day,

I have a form that is attached to a query pulling selected records from a
table. My problem is when two users enter the form they both pull up the same
record. I am trying to find out how to set the form up so that no two users
start on the same record.

Any ideas would be greatly appreciated.
 
D

Douglas J. Steele

Are your users both connecting to the same database?

A properly deployed multiuser application should be split into a front-end
(containing the queries, forms, reports, macros and modules), linked to a
back-end (containing the tables and relationships). Only the back-end should
be on the server: each user should have his/her own copy of the front-end,
ideally on his/her hard drive.

(Actually, which I said that's how it should be for a "properly deployed
multiuser application", I actually believe all applications, even
single-user ones, should be split.)
 
A

Adonna

Doug,

No I did not split this database. It actually was created by someone else
and I was told to tweak it so that it would meet the needs of the current
project. Would splitting the database fix my issue of multiple users
accessing the same record when opening the same form?

I will try this tonight. Can't hurt.

Thank you so much for your help.
 
Top