Search

[Craig]

Hi

Thanks for taking the time to look at this for me !

I have a form which has 8 combo boxes with
Good;Average;Poor for their selection value. I want to
create a search button that ignores the combo box's if
they have nothing selected, but find records with the the
corresponding Combo boxes.

Hope this makes sense !

example

Combo1-6 = No selection
Combo7 = Good
Combo8 = Average

I would like my query to pick up all records that have
Combo 7 as good *OR* Combo8 as average. with anything in 1-
6

Hope I've explained it correctly

Thanks for any help !
Craig

 

[JohnFol]

I presume each combo relates to a different field

So the criteria in the QBE is:
[Field1]
=Forms!FormName!Combo1 or isnull(Forms!FormName!Combo1)

 

[Craig]

thanks John

I'll give that a try !

Craig

-----Original Message-----
I presume each combo relates to a different field

So the criteria in the QBE is:
[Field1]
=Forms!FormName!Combo1 or isnull(Forms!FormName!Combo1)

Hi

Thanks for taking the time to look at this for me !

I have a form which has 8 combo boxes with
Good;Average;Poor for their selection value. I want to
create a search button that ignores the combo box's if
they have nothing selected, but find records with the the
corresponding Combo boxes.

Hope this makes sense !

example

Combo1-6 = No selection
Combo7 = Good
Combo8 = Average

I would like my query to pick up all records that have
Combo 7 as good *OR* Combo8 as average. with anything in 1-
6

Hope I've explained it correctly

Thanks for any help !
Craig

.

 

[Asaf Bar-Lev]

What if you want all records if there is null in the combobox?

thanks John

I'll give that a try !

Craig

-----Original Message-----
I presume each combo relates to a different field

So the criteria in the QBE is:
[Field1]
=Forms!FormName!Combo1 or isnull(Forms!FormName!Combo1)

Hi

Thanks for taking the time to look at this for me !

I have a form which has 8 combo boxes with
Good;Average;Poor for their selection value. I want to
create a search button that ignores the combo box's if
they have nothing selected, but find records with the the
corresponding Combo boxes.

Hope this makes sense !

example

Combo1-6 = No selection
Combo7 = Good
Combo8 = Average

I would like my query to pick up all records that have
Combo 7 as good *OR* Combo8 as average. with anything in 1-
6

Hope I've explained it correctly

Thanks for any help !
Craig

.