|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 7th, 2006, 05:02 PM
posted to microsoft.public.access.forms
|
|||
|
|||
how do i go straight to 'add a new record' from a Command button?
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 
|
|
#2
December 7th, 2006, 06:10 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
how do i go straight to 'add a new record' from a Command button?
In the load event of the form:
Docme.GotoRecord acNewRec "Craig" wrote: 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
|
|
#3
December 7th, 2006, 07:41 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
how do i go straight to 'add a new record' from a Command button?
DoCmd.GoToRecord , , acNewRec
Craig wrote: 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 -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1
|
|
#4
December 13th, 2006, 09:32 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
how do i go straight to 'add a new record' from a Command butt
Thanks for that. I'm fairly new to access. Do i go to the form that contains
the 'add to inventory' command button and right click to access the properties dialogue box. I've found the event tab but nothing called load? All help much appreciated. "Klatuu" wrote: In the load event of the form: Docme.GotoRecord acNewRec "Craig" wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
