Im working in access 2003. Ill just start with the query, im trying to populate a combobox with:
SELECT DISTINCT [Feeder Property Values].value FROM [Feeder Property Values] WHERE ([Feeder Property Values].[feeder property key]=3 And ([Feeder Property Values].value Like (ComboState.Value) & '.%'))
this works when I dont include the part after the AND. when I include the part after AND i get nothing.
[Feeder Property Values].value looks like this: UT.GGR.CKB.GGR17.ZKVA
and ComboState is a combo box with two letter state abbreviatsions (UT, CA, ID, etc).
Im trying to narrow the query down to just [Feeder Property Values].value that begin with the two letters currently selected in ComboState.
Any thoughts.