Adding Multiple Records to SubForm

[JPetersen]

I want to add several records to the subform. This works until line 4 (error 2105; can't go to specified record. Can't I keep adding records like this?

Me.frmMissingItems_Subform.SetFocus

DoCmd.GoToRecord , , acNewRec
Forms!frmPCSTracker!frmMissingItems_Subform!MissingID = "1"

DoCmd.GoToRecord , , acNewRec
Forms!frmPCSTracker!frmMissingItems_Subform!MissingID = "2"

DoCmd.GoToRecord , , acNewRec
Forms!frmPCSTracker!frmMissingItems_Subform!MissingID = "3"

[twinnyfo]

If I read your code correctly, you are adding a record to the main form, not the subform.

I would ask why you want or need to add records to a subform programmaticall y. This might help us understand what you are trying to do and offer, perhaps, some alternate solutions.