justice8965
Registered User.
- Local time
- Today, 08:44
- Joined
- Aug 25, 2009
- Messages
- 32
Hey all
I have a form where a user can select, using check boxes, what types of defects from a sheet of metal they want. They then hit a button and it brings up the query results, showing all sheets with, for example, defect type 1 and type 4. The defect types are labeled as numbers.
What I've been trying to do is send the query a string based on what they choose. For example, the string would be "1 Or 4 Or 5" if they selected 1, 4, and 5.
I am able to make the string, and send it to the query by calling a function in the criteria. However, every time I try to include more than one defect type, I get a data mismatch error. If I choose just one defect, it works fine. I can confirm by stepping thru the code it is getting sent the correct string ie "1 Or 4", but it won't accept it.
Any ideas?
I have a form where a user can select, using check boxes, what types of defects from a sheet of metal they want. They then hit a button and it brings up the query results, showing all sheets with, for example, defect type 1 and type 4. The defect types are labeled as numbers.
What I've been trying to do is send the query a string based on what they choose. For example, the string would be "1 Or 4 Or 5" if they selected 1, 4, and 5.
I am able to make the string, and send it to the query by calling a function in the criteria. However, every time I try to include more than one defect type, I get a data mismatch error. If I choose just one defect, it works fine. I can confirm by stepping thru the code it is getting sent the correct string ie "1 Or 4", but it won't accept it.
Any ideas?