I have a tbl_Demo that is linked one to many to tbl_Services on DemoID.
I have a form for tbl_Demo with a continuous subform for tbl_Services.
Referential Integrity is turned on.
Before ever going into frm_Demo, there is an intermediary form with a button that first checks for overlaps and such. The button then opens frm_Demo and populates a couple of fields. It also needs to create 16 records to start out with in the subform.
I can't use DoCmd.GotoRecord , , acNewRec. Something about how I can't use that on a form in Design View.
I can't use DoCmd.GotoRecord , "frm_Sub_Services". Says that it's not open.
I tried to do it through the subform's recordset clone but it says there needs to be a related record in tbl_Demo. Then again, I didn't set the value of tbl_Services.DemoID to match tbl_Demo.DemoID. But the whole point of referential integrity was to avoid this.
Is there another method?