424,066 Members | 2,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,066 IT Pros & Developers. It's quick & easy.

Multiple criteria for a FindRecord/FindFirst

100+
P: 110
Hello

How do I specify multiple criteria for FindFirst or FindRecord (or anything else) that takes the criteria from a form. (text field and number field)

edit:
this will be in the after update event for a list box. my intent is that user can select a value from the list box based on which other list box will be filled.
the search criteria will take in value from the first list box and customer number from another control on the main form

Thanks
Mar 14 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,286
You use AND and OR with parentheses to group statements together.
Mar 14 '07 #2

100+
P: 110
Thanks found it.

Yeah, thats essentially what i am doing now, using AND
Mar 15 '07 #3

Rabbit
Expert Mod 10K+
P: 12,286
Good luck, let us know if you have any more problems.
Mar 15 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.