Set focus

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I send the focus to a new record in a subform (below is the address of
the sub form). I use this

Me.[CallCommentsT].Form![CallCommentsNotes] = "Contacted Not Intersted"
Me.[CallCommentsT].Form![CallContacted] = True

to send values to a subform but if I don't remember to click on a new record
it will overwrite my comments from previous.
 
Try this:

Dim frm As Form
Set frm = Me.CallComments.Form

Me.CallComments.SetFocus
DoCmd.GoToRecord Record:=acNewRec
frm!CallCommentsNotes = "Contacted Not Interested"
frm!CallContacted = True

Ken Sheridan
Stafford, England
 
You must log in or register to reply here.

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

Subform Address 3
Subform Address 4
Subform field focus 3
set focus to subform 10
member already exists in an object module... 6
Close on Lost Focus 2
setting the Focus to the current record in a multiple record subfo 1
Subform Navigation 12

Back
Top