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

How can I use a wildcard in a form that runs a query?

P: 2
I have a form with Combo Box drop down menus:

Last Name: [combo box]
First Name: [combo box]

The form posts to a table.

I have a query that pulls the data with a 1 to 1 relationship made between the data table and the form table.

Communications related to that person are displayed in a report. Now, I can select the last name and the first name and see all communications with that person. I would like to be able to select last name only and see all communications for people with that last name. I tried adding a wildcard to the first name combo box and that returns no results. Is it possible to do what I am trying to do?

Mar 31 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 931
Hi -

Generally, you would simply want to set the query criteria so that it looks for whatever last name the user picked from the last name combo box...and that's it. No need to put a wildcard in for the first name.

Mar 31 '10 #2

P: 2

Thanks for your help.

When I leave the first name field blank, I get no results. This is due to the 1 to 1 relationship between the form table and the data table in the query. To solve the problem, I just created a new query, table, and report that only used last name as criteria.
Apr 1 '10 #3

Post your reply

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