VBA Code (GoTo New Record)

[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...

 

[Daniel Pineault]

Have you tried

DoCmd.GoToRecord ,,acNewRec
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[karim]

Thank you very much...works well

Have you tried

DoCmd.GoToRecord ,,acNewRec
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[John W. Vinson]

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...

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