how do i go straight to 'add a new record' from a Command button?

C

Craig

I am producing a stock inventory and have a command button called Add To
Inventory. When i click on this it brings up the relevant records but starts
at record number 1. How do i set up this command button to open at the add
new record stage rather than having to click the additional add new record
button to get to the end?

Thanks in advance
Craig
 
M

missinglinq via AccessMonster.com

DoCmd.GoToRecord , , acNewRec
I am producing a stock inventory and have a command button called Add To
Inventory. When i click on this it brings up the relevant records but starts
at record number 1. How do i set up this command button to open at the add
new record stage rather than having to click the additional add new record
button to get to the end?

Thanks in advance
Craig
Click to expand...
 
Top