Add a record only by clicking button

A

Alex

Is there a way to not let users add a new record in a form by tabbing through
all fields or using their mouse roller? I've hidden the navigation buttons
and I have some code in the New Record button and I only want them to be able
to add a new record by clicking the button. Thank you.
 
J

JethroUK©

me.allowadditions = No


you will have to disable this when adding a new record with your button
 
K

Klatuu

yes, but it is a lot of work. An easier approach would be to move the code
to the Current event of the form. Then, regardless of how they add a record,
the code will execute:

If Me.NewRecord Then
'Put your code here
End If
 
Top