Add a record only by clicking button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
me.allowadditions = No


you will have to disable this when adding a new record with your button
 
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
 
Back
Top