Share via

Command Button Wizard > Record Navigation

Anonymous
2024-06-17T18:46:33+00:00

Good day. Is there an option on a data entry Form to add a Command Button that will go to a New (Blank) Record? Meaning a new row that is Blank so a new Entry can be added. Thanks in advance. Best, CP

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

George Hepworth 22,855 Reputation points Volunteer Moderator
2024-06-17T19:41:46+00:00

Sure. Add a command button to the form. You can do that from the ribbon.

Add code to the "Click Event" of this command button. Here's one possible way. There are several other ways to accomplish the task. Note that there is no error handling in this sample.

Private Sub cmdYourNewAddButton_Click()

  If Not Me.NewRecord Then 

      Me.Recordset.AddNew 

  End If 

End Sub

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest