By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,454 Members | 3,103 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,454 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,366
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,366
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.