Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form Help!

Status
Not open for further replies.

Caryisms

Technical User
Oct 17, 2001
132
0
0
US
I want to prevent users from entering more than record at a time from the data entry form. I have greyed out (de-selected) the default menus, and taken away the navigation buttons. When I start to fill out the form, the [Insert New Record] selection is no longer greyed out in the default menu list. It is a single form view. Help!

 
Caryisms

You can add

DoCmd.Close acForm, Me.Name, acSaveYes

to the AfterInsert property.

Jim

"Get it right the first time, that's the main thing..." [wavey]
 
I don't quite know what the context is but could you do something straighforward like:

Set the Cycle property for the form to Current Record and provide an exit button so users have little option but to add a single record and then quit the form.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top