DoCmd.GoToRecord , , acNewRec to Sub Form

  • Thread starter Thread starter Silvio
  • Start date Start date
S

Silvio

This is what I have for cmdAddRecord:

Me!Mysub!EstAdmin = Me.TxEstAdmin
Me!Mysub!EstBuilding = Me.TxEstBuilding
DoCmd.GoToRecord , , acNewRec

I need to refer this last line to the sub form (MySub) and not the main
form. How?

Thanks!
 
You need to get the focus into the subform so that the final line works
there and not in the main form.

That's a 2 step process:
1. Make the subform control the active control of the main form.
2. Set focus to something in the subform.

Try:
Me.MySub.SetFocus
Me.MySub.Form!ExtAdmin.SetFocus
RunCommand acCmdRecordsGotoNew

Not sure if you intend the 2 text boxes to be populated after you go to the
new record? If before, explicitly save those changes before you try to move
record, i.e.:
Me.MySub.Form.Dirty = False
 

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

acNewRec works inconsistently 11
DoCmd.GoToRecord , , acNewRec is not working 0
Calling subs in another form 1
Combining code isn't working 5
Controlling a Sub Form 4
Access Access 2007 New Record Command for subform 0
Display Last Record 1
DoCmd.GoToRecord , , acNewRec Problem 1

Back
Top