Can you pass more then 1 criteria using the find method..
part_code = '01500' works but
part_code = '01500' AND TYPE = 'A' DOES NOT WORK..
any help would be appricated..
Brooke
Printable View
Can you pass more then 1 criteria using the find method..
part_code = '01500' works but
part_code = '01500' AND TYPE = 'A' DOES NOT WORK..
any help would be appricated..
Brooke
It appears as though you can't do it with the ADO Find method. I tried two examples, one with a single criterion, the other with an "AND", and it balked at the "AND" example. In looking at the Help topic on the ADO Find method, it says the criteria part must be a field, followed by a comparison operator, followed by a value - and it appears to be limited to just that. This behavior is unlike the DAO FindFirst, FindNext, etc. methods that DO accept multiple critera.
I know this is not what you wanted to hear, but I gave it a shot and couldn't get it to go. Good luck.