Solved Add record in formB from formA (1 Viewer)

[NearImpossible]

I have a main form with a tabctrl, and on tab 7 i have 2 forms that we will call formA and formB, both linked to the main form via facilityID

What I would like is to click a button in formA that will add a new record to formB.

When I try either of the following

Forms!formB.Form.Recordset.AddNew

or

Forms!FormB.SetFocus
DoCmd.GoToRecord , , acNewRec

I get the following "Run-time error '2450': Micorsoft Access cannot find the referenced form 'formB'

As these forms are on a tabctrl, i guess im not sure how to reference formB from formA.

please advise

 

[CJ_London]

try

Parent.formB

 

[NearImpossible]

try

Parent.formB

That did it, thanks a million !!

 

[arnelgp]

it's always inside the Main form:

Forms!mainFormName!FormB.Form.Recordset.Addnew

 

[NearImpossible]

it's always inside the Main form:

Forms!mainFormName!FormB.Form.Recordset.Addnew

Thanks for the clarification, i'll remember this for next time !!

 

[Pat Hartman]

It is almost always wrong to create "empty" records. It means that you are not bothering with any validation. So, empty fields, fields with incorrect data all get saved. Seriously poor practice.