G
Guest
Trying to populate a second combo box in a Form based on the user data input
into the first combo box in the same form.
The all combo boxes are bound to text fields. The statement I’m using is:
SELECT DISTINCT [SubCategory] FROM tblSubCat WHERE
[tblSubCat].[Category]=[Forms]![TestHistoryForm].[txtClaCategory_tab];
Is this the correct syntax for the source on second combo box on the form?
It doesn’t populate at all using the = operator. I do get the second combo
box to populate (with incorrect data) if the operator is <>. What could be
the problem? Any help is appreciated.
into the first combo box in the same form.
The all combo boxes are bound to text fields. The statement I’m using is:
SELECT DISTINCT [SubCategory] FROM tblSubCat WHERE
[tblSubCat].[Category]=[Forms]![TestHistoryForm].[txtClaCategory_tab];
Is this the correct syntax for the source on second combo box on the form?
It doesn’t populate at all using the = operator. I do get the second combo
box to populate (with incorrect data) if the operator is <>. What could be
the problem? Any help is appreciated.