By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

Search form in access

P: 1
I have built a search form in access and it has 4 combo boxes. I am trying to write a syntax so that if a combo box has no criteria is shows all records. For example, if a user has a following search terms:

Author:
Industry: Financial
Source Type: Analyst reports

To make this clear the "author" combo box in blank and therefore it should display results based on the other 2 parameters. Does any one know how to make this work. Let me know. Thanks
Mar 10 '08 #1
Share this Question
Share on Google+
1 Reply


JustJim
Expert 100+
P: 407
I have built a search form in access and it has 4 combo boxes. I am trying to write a syntax so that if a combo box has no criteria is shows all records. For example, if a user has a following search terms:

Author:
Industry: Financial
Source Type: Analyst reports

To make this clear the "author" combo box in blank and therefore it should display results based on the other 2 parameters. Does any one know how to make this work. Let me know. Thanks
Hi,
I'm presuming that you are doing this in code.

DIM string variables for each of the combo box values and concatenate the variables into a search string. That way if the value of a combo box is null, that part of the search string will be the empty string ("").

If that isn't clear, post again and I'll give you a code example.

Jim
Mar 20 '08 #2

Post your reply

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