I may be way off on this but I'm trying to "filter" a drop down list control in my form. I can use the following as the row source to get all the values from the table....
SELECT [ICNTable].[ICNNumber] FROM ICNTable ORDER BY [ICNNumber];
But the ICN # is a combination of the CRN # (first 7 charactions) plus 4 characters. I've used this type of syntax before in writing queries in VB but I was hoping to use it as the row source for the drop down box. I don't get a syntax error when I run the form but it still shows me all the records when I want just the ones that have a specific value in the first 7 places. Is this possible?
SELECT [ICNTable].[ICNNumber] FROM ICNTable WHERE "left(ICNNumber,7) = " & chr$(34) & CRNNumber & chr$(34) ORDER BY [ICNNumber];