Problems with a subform

[JenNorthwood]

Hi There

I have a form and a subform. I have a combo box called Combo16. I am trying to choose an option from Combo16 and then it appears in the subform Combo box - Combo10.

Combo16 = Combo10

Problem: I get an error saying it can't find the subform. I have made sure that all spelling is corrected.

Any suggestions, Here is my code.

Private Sub Combo16_AfterUpdate()
[Forms]![frmTest]![Combo16] = [Forms]![sfrmTest2]![Combo10]


End Sub

Thank you,

Jen

 

[Rich]

Just wondering why you'd want the same value in two tables?

 

[JenNorthwood]

The main form is a form for a course. The subform is a Continuous Form to pick all the poeple who took the course.

There is also a place for the date and course length in the subform.

I don't want to have to type in the date and course lenght for every person in the Continuous Form.

So I figured if I put the options in the main form, they can put those values into the subform, therefore, not having to type in the value each time.

Jen