Lock Form

[Novice1]

I have a form I want to limit to one user at a time. When the form is open, I want it to lock. I want the form to unlock when the user exits the form.

I don't want to lock records ... only the form.

Any help will be appreciated.

 

[Rabbie]

This could cause you issues if you implement it. What will happen if a user enters the form and then doesn't Exit from it? If you have more than 1 user you should havesplit your DB in any case so each user will have their own FE with forms etc.

Why do you need to lock the form? One way would be to set a marker record in a record in a table when you enter the form and check that this is not set before the form opens. Remember to clear this when you exit the form

 

[missinglinq]

Rabbie's advice about splitting the database is spot on, and the question "Why do you need to lock the form?" is really important! On the face of it this is a very strange requirement.

Linq ;0)>

 

[boblarson]

Rabbie's advice about splitting the database is spot on, and the question "Why do you need to lock the form?" is really important! On the face of it this is a very strange requirement.

Linq ;0)>

Inquiring minds want to know...

 

[smig]

surprisignly I have a similar need

this go back to my question - Binding vs Recordsets http://www.access-programmers.co.uk/forums/showthread.php?t=200296

binding a form to a table will lock the records, but when using Recordsets there is a chance of few users to work on the same task.
even if I bind the forms there are cases in my application where two users can do the same taks (In my case collecting bills for payments for example)

I know how to limit the user (by setting a flag in the table) and clearing it when the user go to another record.
description of what I want:
I have a main form. on this form there is a subform, and few ones inside (3 levels)
on the main form there is a record selector so I can change the records shown on main form and subforms.
I want the user to be able to change records with no interaption but to not leting him going into any of the subforms if the record is locked.

my problem is I can't find a way to triger when the user try to go into the subforms.