Add record to Subform using Add Record button

[matey56]

Hi,
I have an Add Record button on my form that I want to use to add records to a subform. I am using the following code:

Private Sub cmd_Add_Record_Click()
Forms![frm_Label_Tracking]![sfrm_Label_Tracking].SetFocus
DoCmd.GoToRecord , , acNewRec
End Sub



It's giving me an error telling me it can't find the subform field 'sfrm_Label_Tracking'. What am I doing wrong? Or this the wrong way to go about it?

[davegri]

In a proper form/subform setup you don't need a button at all. Just start typing into a new row in the datasheet subform.

[kd2017]

Maybe try

Me!sfrm_Label_Tracking.SetFocus

[matey56]

In a proper form/subform setup you don't need a button at all. Just start typing into a new row in the datasheet subform.

My subform isn't a data sheet. It's a customized form view. At the form level I have a combo box with a list of product names. When you select a product it brings up all the records with that product name in the subform. Right now I have no way to add another record to the subform.

[matey56]

Maybe try

Me!sfrm_Label_Tracking.SetFocus

That didn't work. :-(

[kd2017]

Hi,
I have an Add Record button on my form that I want to use to add records to a subform. I am using the following code:

Private Sub cmd_Add_Record_Click()
Forms![frm_Label_Tracking]![sfrm_Label_Tracking].SetFocus
DoCmd.GoToRecord , , acNewRec
End Sub

It's giving me an error telling me it can't find the subform field 'sfrm_Label_Tracking'. What am I doing wrong? Or this the wrong way to go about it?

You're code actually works fine in my test. Double check that you haven't misspelled something.

To davegri's point, you can click the little arrow with a star on the bottom left of the subform to jump to a new record.

[Welshgasman]

Perhaps Me.[sfrm_Label_Tracking].Form.SetFocus ?

Found this with a quick Google, have a read. http://datagnostics.com/dtips/formsubformfocus.html

[davegri]

If you really want a button, how about moving it from the main form to the subform?

[Missinglinq]

The problem could be because you cannot Set Focus on a Form if it has one or more Controls that can have data Added/Edited. To move to a Subform , via code, you have to Set Focus to the Subform Control on the Main Form...which may or may not have the same name as the name of the Form the Subform is based on.

The Form your Subform is based on apparently is sfrm_Label_Tracking...but is that the name of the Subform Control it resides in?

Linq