input form

[Guest]

I have a input form and would like to limit its use to one user at a time. Is
there a way to determine if the input form is open, and then using an elseIf
statement to restrict access to others while the information is being input.

 

[Guest]

Just curious as to why you want to do this. The locking should take place at
the table or record level you should not lock via forms. It seems like you
want to enter data in a serialized way. Could you just explain a little more
about the intentions of showing the form to just one person at a time?

 

[Guest]

yes I am trying to enter data in a serialized way, the input form is related
to two table with a one to many relationship, but I have had problems with
users starting records, and not finishing them, submitting duplicate request,
then going back to edit a request and editing the wrong record. I am have a
problem with data integrety.