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
|
|||
|
|||
Add New Record in Datasheet subform
Hi All,
I have an event on my main form that when you press enter it moves the cursor to the first record on the subform. However I want it to place the cursor on the add new record portion of the subform if there is data already found. I hope I am saying this correct. -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Add New Record in Datasheet subform
Me.sfrOrders.SetFocus DoCmd.GoToRecord , , acNewRec Where 'sfrOrders' is the name of the subform control. -- Brendan Reynolds Access MVP "mattc66 via AccessMonster.com" u16013@uwe wrote in message news:67064c73f17c7@uwe... Hi All, I have an event on my main form that when you press enter it moves the cursor to the first record on the subform. However I want it to place the cursor on the add new record portion of the subform if there is data already found. I hope I am saying this correct. -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Add New Record in Datasheet subform
That works great - Thank you!
Brendan Reynolds wrote: Me.sfrOrders.SetFocus DoCmd.GoToRecord , , acNewRec Where 'sfrOrders' is the name of the subform control. Hi All, [quoted text clipped - 5 lines] I hope I am saying this correct. -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200609/1 |
Thread Tools | |
Display Modes | |
|
|