Restrict form to adding only one new record

[Tom G.]

I have a database that only has one form. The form opens when the database
is opened and the Data Entry property is set to Yes so that each use of the
database requires the user to enter a new record.

I need to prevent the user from entering any additional new records during
any single use of the database. I removed the record navigation buttons from
the form and set the Cycle property to Current Record. But, a user can still
advance to a new blank record using the scroll wheel on their mouse.

How can I prevent this and lock the form down to allow only one new record
per use?

Thanks!
Tom G.

 

[John Welch]

How about using an unbound form with a button that when clicked appends the
data to the proper tables and then is disabled?

 

[askjerry]

Put some code in the forms After Update Event to close the form and the
application. If you do not want to close the application then set a
global variable and and if it is set do not let the user reopen the
form.

 

[guido]

You can set the forms cycle property to "current record", the navigation
buttons property to "no".
The user could still insert a new record from the "Insert" menu at the top of
the screen, so if it is necessary to totally lock it down, code would have to
be added to prevent that.