Creating new record in subform

[BaudKarma]

I've got a form with a linked subform. The subform displays continuous records. I have code in the main form that looks up data in an external table with dlookup, then adds it to the subform with:

Forms![frm1].Form![subfrm1]![Field1] = txt1

Which works just fine until it's time to add another record. I don't know how to code commands to tell the subform to add a new record, so I'm just overwriting the existing data. Any advice on a better way to handle this?



I try not to let my ignorance prevent me from offering a strong opinion.

 

[TheAceMan1]

How are ya BaudKarma . . . . .

I query your form referencing!

Try this:

[blue]   Me![purple][b]YourSubformName[/b][/purple].SetFocus
   DoCmd.RunCommand acCmdRecordsGoToNew
   'Your assignments here[/blue]

See Ya! . . . . . .