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

0 vote256 views1 answer
Excel vba paste all to each sheet in workbook
VBA
22 votes313 views1 answer
Excelvba check for directory
VBA
0 vote258 views2 answers
Get unique random number in vb.net
VBA
0 vote243 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote248 views1 answer
Remove series name from legendvbnet
VBA
0 vote247 views1 answer
Excel vba cell on change
VBA
1 vote246 views1 answer
Extract the second word in a text in excel
VBA
0 vote253 views1 answer
Excel vba combine ranges
VBA
0 vote252 views2 answers
Excel vba copy paste after last row
VBA
0 vote234 views1 answer
Excel vba copy entire sheet paste values
VBA