Query parameters for search

Hi all out there..

Am I on the right track? I have set up a query to search my records. I want
to search by 6 fields which are inputted from a Form. I am using

Like [Forms]![frmMembers]![combobox] & "*" or Is Null

as the criteria where combobox are the parameters entered on the form. Im
getting all of my records returned with any search, is this because when a
combobox is empty, it adds every record?

What I want, is:
1 The query uses the comboboxes for the search parameters
2 If all comboboxes are empty, all records are returned.
3 If a combobox is filled in, but another is empty, the search only uses the
filled in combobox.

Any suggestions?

Thanks all...

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200605/1
.

Relevant Pages

  • RE: updated numbers in report
    ... it is looking as you have described, when using only the criteria from the ... for the input in the query it is not. ... i was thinking this, that the combobox ... have a list from the table, and the textbox have not. ...
    (microsoft.public.access.dataaccess.pages)
  • RE: updated numbers in report
    ... criteria for a number of queries. ... But i have one more question, its about a textbox. ... textbox will be located alongside with the combobox where the belonging ... will not make the input to the query. ...
    (microsoft.public.access.dataaccess.pages)
  • Tables Queries Criteria oh my!
    ... Transactions Out-- This is where we store the information about the ... everything is working fine except for ONE query. ... gets its information from a combobox on a form. ... query only seems to accept the criteria if one particular product is ...
    (comp.databases.ms-access)
  • Re: AllowAdditions=False makes unbound controls blank out when recordcount=0.
    ... If the RecordSource is not a read-only query, one workaround is to allow the ... You can place other controls in the Form Header section and they are ... there are still display problems with those ... > the after update event of the combobox. ...
    (microsoft.public.access.forms)
  • Re: Current Row or similar for query-based combo box
    ... Based on a prior post, I have created a form to access my table. ... form.in my combobox query I am able to get the intended result. ... rows that need other values to display will suddenly display blank. ...
    (microsoft.public.access.queries)