Goto New Record using VBA

karim · Feb 26, 2009

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 · Feb 26, 2009

See the response to your first post on the matter.

http://www.microsoft.com/office/com...&p=1&tid=6aec578b-c76e-4c81-83d5-74e09f124c2f
--
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 · Feb 26, 2009

sorry, I posted it twice by accident...

Daniel Pineault said:
See the response to your first post on the matter.

http://www.microsoft.com/office/com...&p=1&tid=6aec578b-c76e-4c81-83d5-74e09f124c2f
--
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 Mishefske · Feb 27, 2009

karim said:
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...

There are several ways to do this. This code line placed in the
Form_Load event is one:

DoCmd.GoToRecord acDataForm, Me.Name, acNewRec

--
John Mishefske, Microsoft MVP 2007 - 2009
UtterAccess Editor
Tigeronomy Software
web: http://www.tigeronomy.com
email: sales ~at~ tigeronomy.com