Re: Combo Box complications

Assuming your form with the comboboxes is named FrmSearch, put the following
expression in the Server field of your query:
Forms!FrmSearch!cboServer Or (Forms!FrmSearch!cboServer Is Null)

Use a similar expression for the other three comboboxes.

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx




"Dave" <djwest101@xxxxxxxxx> wrote in message
news:1183150581.411792.96900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I wasn't sure how to search for previous posts about this, it felt
real specific. Ok so here's the database & problem:

I have 4 combo boxes: cboServer, cboPolicy, cboDB, and
cboApplication. The idea behind the database is for a user to search/
select desired information in any kind of combination between the 4
combo boxes. Then the user clicks a button (btnSearch) and
subsequently a query ("Search Function") is run that shows all 4
different data selections from the 4 combo boxes.

Right now if a user selects something from EACH (all 4) combo box and
runs the search, it works fine (all 4 selections are displayed in
their respective columns).

Here's the issue: If the user selects information from only 3, 2, or
1 combo box(es) (not all 4), then the "search" returns nothing at
all. What it should return is a selection from all 4 combo boxes
(i.e. if a user selects a database from cboDB, clicking the search
button should return the Database previously selected as well as the
Server and Policy it resides on, and the Application that runs the
Database.) Depending on the combo box data that is selected by the
user, clicking the search button will find the rest of the data that
is related to the data that was selected by the user previous to
clicking search.

Maybe I'm just having a Friday brain fart, but any help on getting
this working right is much appreciated!! Thanks in advance,

Dave



.