Force new record

[John]

Hi,
I am using a combo box on a main form to populate records in a subform.
1st of all, once a record has been populated i would like the focus to
automatically jump to the new record line.
2nd How can I make the new record line on the subform have focus on openeing
the database?

Is this possible?

Regards

John

 

[Arvin Meyer [MVP]]

Try the following in the Open event of the subform:

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

 

[John]

Arvin,
Thanks for the reply. That works great for opening the form but I also need
the new record field to be selected for the next new record after
population. How would I accomplish that?

Regards

John

 

[Arvin Meyer [MVP]]

Go to Tools >>> Options >>> Keyboard and uncheck the Cursor stops at
First/Last field box.

Now after completing each record, hitting the Enter key will move your
cursor to the first field in a new record. Alternatively, you can use the
scroll wheel on the mouse to move to the next new record (if you've just
completed one)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[John]

Thanks Arvin, it took a bit of finding, I should have mentioned I use Access
2007

Regards

John