I have 2 combos called Event & Sub_Event that filter a list called verses according to the input of the combos.
It works to an extent, but it works on the text in the combo and I want to filter based on it's ID.
Here is the staetment in the query:
The combo is bound to column 1.
How I found that the query was not working correctly, is because I had 2 sub_Events with the word One in them.
Any ideas how I can fix this?
It works to an extent, but it works on the text in the combo and I want to filter based on it's ID.
Here is the staetment in the query:
There are 2 columns in the combo tables typically SID & Event.Like "*" & [Forms]![Find Verse]![cboEvent] & "*" And Like "*" & [Forms]![Find Verse]![cboSub_Event] & "*"
The combo is bound to column 1.
How I found that the query was not working correctly, is because I had 2 sub_Events with the word One in them.
Any ideas how I can fix this?