Am trying to build an application that will be shared with about 4 or 5 users. Want to allow them in this app to do other procedures. I want to stop the option of successive users from using an Add Record form. Here is what basically happens. When they press a <Record Maintenance> button on the opening page, they are presented with all the current records in the database. They can modify any field except the unique customized record number. When they wish to add a new record to the table, they press a command button. A new form appears for input of this information. While this form is open, I wish that no other user have the permission to open the form as the same customized number will be assigned. That presents a conflict on closing one of the forms or loss of a number if the first user should cancel out the input. How can I disable the command button if the Add button has a form open in another instance?
Thank you for stopping by and schooling me.