I have a table with several fields, one is a lookup filed (defined as short text) looking up values from another table.
I have a form that has the above mentioned table as a Record Source. I want to filer this form by the data in the mentiond lookup field. I have created a combo box on the form to filter this data and in the Record SOurce have added this control to the Criteria
of the Record Source Query.
But When I try to filter by the lookup column I get nothing. Does the lookup column state the actual text string that is displayed and does the lookup values in the table display the txt string or only a reference value to the original table?
If I have CustomerID CustomerName
And on the original table I have a lookup to Customer Name
and on the form I want to filter by Customer Name
Are all these values stored as text so I can filter by text? What am I doing wrong here?