Run Time Error in Form with ComboBox

M

monia13

I'm getting this error when I choose a value in the combobox:

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

Aslo under the AfterUpdate I have this code:
 
K

Klatuu

Yes, you are trying to use a subform as a row source for your combo. It
needs to be a query, a table, or a list
 
M

monia13

The row source is set up properly: Table/Query

In the form I have a suboform based on the query. The query is filtered
based on the choice in the combo box.
 
K

Klatuu

Sorry, I got confused by your original post. Must be the syntax in your
query, then. It seems to think the name of your subform is a field name. I
would check the criteria in the subform's query. It should be referencing:
forms!MainFormName!ComboBoxName
 
M

monia13

Yep, that's exactly what I have as a criteria in the query. When I run the
query from the Query panel, it asks me to input the critia. After I manually
type it in, the query produces results. I don't understand how come the same
results won't appear in the form.
 
K

Klatuu

Sorry, I'm stumped. The only other thing I can think of is the data type it
is expecting, but that is only a wild guess.
 
M

monia13

Is it possible that it has something to do with BoundColumn or UnboundColumn
feature?
 
Top