Selecting records in a subform

[Guest]

How do I get a combo box in a subform to provide a list of records that is
bound to another field and only lists those records based on a record I
select in that other field. In a form, I am able to do this with no problem
using a SELECT query. However, in a subform, the query works only if I open
the subform by itself. When used in connection with the Main form the query
no longer works.

 

[Steve Schapel]

George,

It sounds like you are using a reference to a form control in the
criteria of the query. In this case, you will need to refer properly to
a control on the subform, using syntax such as...
[Forms]![NameOfMainForm]![NameOfSubform]![NameOfControl]
or...
[Forms]![NameOfMainForm]![NameOfSubform].[Form]![NameOfControl]