Locking a form

[Mossie]

Hi

I'm new to Access and are in need of some assistance.

I've got a database that consists of 4 different tables and 4 Forms.
There are 4 PC's connecting to the same database.

I want to create a menu with the forms as options.
Is it possible that when a user logs in to a form, Access locks that form and the rest of the users can't access it.

Thank you,
Mossie

[PeterDavis]

Hi

I'm new to Access and are in need of some assistance.

I've got a database that consists of 4 different tables and 4 Forms.
There are 4 PC's connecting to the same database.

I want to create a menu with the forms as options.
Is it possible that when a user logs in to a form, Access locks that form and the rest of the users can't access it.

Thank you,
Mossie

You could have a lookup table containing 1) a formId, 2)the form name and 3) a boolean flag for 'locked"

When someone opens a form, the flag is updated to true (locked) and when closed, it is updated to false (available).

So, before opening, your command button would have to check the value of that flag (eg using DLookup)