Hey All,
I am having trouble with my code on a click button on a subform. I want a click event on my subform to copy data from main form to field on subform. A little background: field on main form is a Key Field, field on subform is just the linking field between the two tables. (Main form data is the One Table, subform is the Many Table) So I want to create my one table and then assign the many table with the Key field #. I have a click button on the subform which is a continuous form and the click event copies the field from the main form. What am I missing in this code?
Private Sub Command12_Click()
Me.[VSHIPID] = [frmVenShipEntry].[Form]![VSHIPID]
End Sub
I keep getting an error message when I click my button on the subform. Run-time error '2465': Microsoft Access can't find the field '|1' referred to in your expression. ?
I am having trouble with my code on a click button on a subform. I want a click event on my subform to copy data from main form to field on subform. A little background: field on main form is a Key Field, field on subform is just the linking field between the two tables. (Main form data is the One Table, subform is the Many Table) So I want to create my one table and then assign the many table with the Key field #. I have a click button on the subform which is a continuous form and the click event copies the field from the main form. What am I missing in this code?
Private Sub Command12_Click()
Me.[VSHIPID] = [frmVenShipEntry].[Form]![VSHIPID]
End Sub
I keep getting an error message when I click my button on the subform. Run-time error '2465': Microsoft Access can't find the field '|1' referred to in your expression. ?