VBA Code (GoTo New Record)

  • Thread starter Thread starter karim
  • Start date Start date
K

karim

Hello All,
Is there a code to have the form to go to a new record OnOpen using
VB Code? I know how to do this using Macros, but I would like to know how to
do this using VBA. Thanks for your help...
 
Hello All,
Is there a code to have the form to go to a new record OnOpen using
VB Code? I know how to do this using Macros, but I would like to know how to
do this using VBA. Thanks for your help...
Click to expand...

Use the form's Load event (when the recordset has been populated) not the Open
event (which fires before the data is pulled from the table), and use

DoCmd.GoToRecord acForm, Me.Name, acNewRecord
 
Back
Top