I know I've this before but I can't remember exactly how. On a form, I have a textbox (txtPicked) which is populated with a series of numbers froma multi select list box, ie: 5771 or 1000 or 2000
I'm trying to pass this into a query as the criteria but by directly pointing to the forms textbox, its reading it as a string, ie: "5771 or 1000 or 2000"
Since the field is numeric and the criteria is technically a string, it won't return any results. Any ideas?
I'm trying to pass this into a query as the criteria but by directly pointing to the forms textbox, its reading it as a string, ie: "5771 or 1000 or 2000"
Since the field is numeric and the criteria is technically a string, it won't return any results. Any ideas?