Forms

[Lime1969]

Hello all,
I have a form with 4 Text boxes in the form header that are unbound because I have the control source set to a table list for each. In the details part of the form I have results of the query based on what is chosen above. Here is the issue. I need the for it display the results even when one of drop down text boes are blank. So if for instance if the user chooses say "Location" from one of the drop down is shows the results below, enen though the remaining drop downs are blank. Any and all help is grealt apprciated..

THanks

[alansidman]

What is in the criteria for each of the fields in your query? I suspect that you need a wildcard at the end of the criteria. ie. & "*"

Alan

[Lime1969]

My Query states for each possible dropdown [Forms]![Location]![Locations] keeping in mind the Locations is seperate table. Where would I put thw wildcard in the query? at the or?

[alansidman]

Try this:
[Forms]![Location]![Locations] & "*"

Because I suspect each criteria is on the same line, it creates an "and" requirement.

Alan