Update Subform

[Novice1]

I want to go to the subform, add a record then place data in a field (MissingID). First two lines are okay but I'm getting an error on the third line (data member not found). Am I referring to the field incorrectly?

Me.frmMissingItems_Subform.SetFocus
DoCmd.GoToRecord , , acNewRec
Me.frmMissingItems_Subform.MissingID = "abc"

 

[Minty]

Make this link a favourite http://access.mvps.org/access/forms/frm0031.htm
From the main form Me!Subform1.Form!ControlName

 

[Novice1]

Thanks for the reference

Me.frmMissingItems_Subform.SetFocus
DoCmd.GoToRecord , , acNewRec
Me!frmMissingItems_Subform.frmPCSTracker!MissingID = "21"

I modified the code but now I'm getting Error 438 (Object doesn't support this property or method)

 

[Novice1]

Got it to work ... thanks Minty

Me.frmMissingItems_Subform.SetFocus
DoCmd.GoToRecord , , acNewRec
Forms!frmPCSTracker!frmMissingItems_Subform!MissingID = "21"

 

[Minty]

Glad to have helped. If it makes you feel any better I still (after too many years doing this) never get the syntax right first go - I probably look at that web page a couple of times a week...