Subform combo box filtering

N

Nathan

I have a "data entry" form and subform.

The Main form gathers information about a check.

The Subform (datasheet mode) has detail information about the check that
relates to a specific file (any one check may be broken down and applicable
to more than one file). The File Number is unique.

What I need is for a combo box to filter possible Codes for each line of the
subform based on the File ID. I've tried a simple query as the row source
for the combo box that doesn't seem to work:
SELECT Coll.CollID, Colls.CollAssocFileNum
FROM Coll
WHERE (((Coll.CollAssocFileNum)=[CkDetailClaimNum]));

Any ideas?
 
Top