Ms access open form to new record

In the Form_Load event use the GoToRecord Method of DoCmd and pass in acNewRec for the Offset.

Private Sub Form_Load()
   DoCmd.GoToRecord , , acNewRec
End Sub

Source: stackoverflow.com

Similar codes

4 votes136 views2 answers
Vba last row
VBA
0 vote195 views1 answer
String contins in vba
VBA
0 vote192 views1 answer
Change form background image vb
VBA
0 vote186 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
1 vote170 views1 answer
Vba compile error object required
VBA
0 vote201 views1 answer
Group controls programmatically vb
VBA
0 vote181 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote180 views1 answer
Vb net check if file exists
VBA
11 votes406 views1 answer
Excel vba How to URL encode a string
VBA
0 vote191 views1 answer
VB Error Code BC30201
VBA