Add a record into a table via a subform

[nianko]

Hi forum,

I have a main form with several tabs. This main form is blank and its only purpose is to contain the tabs. Each of those tab has one subform linked to its related table. I would like to be able to enter a new item in one of the table via the subform and I used the following code:

Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, Me.tblX_AddItems_subform.Name, acNewRec
End Sub

where tblX_AddItems_subform is the name of my subform.

I obtain a msg error from the debogger: "Compile error: Method or data member not found."

Do you have an idea?

[pbaldy]

That's only going to return the name of the subform I think, and you need the full reference.

http://access.mvps.org/access/forms/frm0031.htm

[nianko]

Hi,

Thanks a lot for the answer. I did have a (prolonged) look at the table and it leaves me a bit confused. I've tried a couple of things, including:

Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, Me.frmAddItems.tblX_AddItems_subform.Form.Name, acNewRec
End Sub

But nothing seems to work (I obtain different types of error now).

To make things a bit clearer:

My main form is called "frmAddItems"
my control (the 6 tabs) is called "TabCtl0" an automatic page I guess
the specific tab I'm working on is called "x"
and the subform is called "tblX_AddItems_subform.Form".

I feel like I've tried all sorts of combinations to get it right, but it's still not working :-(

I'm not so sure eaither when you use the "!".

C

[June7]

You have .Form in the form name? or do you mean the form name is "tblX_Additems_subform"?

What is the name of the subform container control? I always name different from the object contained in the control, like ctrAddItems

Have to first set focus on the subform container control.

Me.ctrAddItems.SetFocus
DoCmd.RunCommand acCmdRecordsGoToNew

[nianko]

Sorry, let's clarify:
name of the form: frmAddItems
I renamed the control as suggested: ctrAddItems (the control that contains the 6 tabs)
and the name of the subform is: tblX_Additems_subform (there is no '.Form')

I've tried this:

Private Sub Form_Load()
   ' Me.frmAddItems.ctrAddItems.SetFocus
    DoCmd.GoToRecord acDataForm, Me.frmAddItems.ctrAddItems.tblX_AddItems_subform.Name, acNewRec
End Sub

And this:

Private Sub Form_Load()
Me.ctrAddItems.SetFocus
DoCmd.RunCommand acCmdRecordsGoToNew
End Sub

but to no avail.

I honestly tied to look for tutorials but it noes not deal with this issue.

C

[June7]

You named the wrong control. Not the tab control - name the subform container control that is sitting on the tab control.