I have a form where the user selects a value from a combobox.
The value of combobox is used in criteria of subform like this :
Code:
Like [Forms]![SearchForm]![cmb1] & "*"
The problem I have is that the values in combobox are stored based on ID so if the user selects e.g. 1 , the results come with : 1, 11,12,13,14 (whatever it has 1 on it ) .
I would like to display only the specific selection (at this point 1)
I tried to remove "*" from the criteria but then the other comboboxes in form don't work together...