Run time error in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm getting this error when I choose a value in a combo box:

Run time error 2465
Microsoft Access can't find the field 'Subform_By_RCA' referred to in your
expression.

Como box is based on a separate table that lists RCA names. Subform_By_RCA
is based on a query set up using 3 tables, including the table RCA names used
in combo box. Could that be a problem?

Private Sub RCA_AfterUpdate()
Me!Subform_By_RCA.Form.Requery
End Sub

Also I have this code for the UfterUpdate in the combo box:
 
Monia,

I assume that the RCA combobox is on the main form that also has the
subform on it? The name of the subform control on the main form is not
necessarily the same as the name of the form that it houses. Is the
form you are using for the subform named 'Subform_By_RCA'? Is the
subform control on the main form also named 'Subform_By_RCA'? If they
are different, your code needs to refer to the name of the subform
control on the main form.
 
Back
Top