Setting SubForm Focus on a New Record in Datasheet view

C

CES

All,
I'm trying to have the focus of a subform go to a new record when the subform gets focus. I've tried the two combinations below but they don't seem to work.
Any suggestions would be appreciated... Thanks in advance. - CES


Private Sub Form_GotFocus()
'Forms!FormContacts!FormTransaction.SetFocus
'Forms!FormContacts!FormTransaction.Form!Me.Combo7.SetFocus

'Me.FormTransaction.SetFocus
'Me.FormTransaction.Form.Combo7.SetFocus


DoCmd.GoToRecord , , acNewRec
End Sub
 
K

kingston via AccessMonster.com

This should get you to the last record:

Me.FormTransaction.Form.Recordset.MoveLast

This might get you to a new record after that:

Me.FormTransaction.Form.Recordset.MoveNext
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to add record in Subform which is in another Subform 1
Populate main form from subform record 0
Set focus in a specific record within a subform 1
How to add record in Subform which is in another Subform 0
Moving from SubForm to MainForm causing the SubForm record to goto add new 1
set focus to control on subform 0
How to set focus on a new record in a datasheet 1
unable to set focus on subform 2

Top