Passing form fields criteria to a Query

[yosik20]

Hey,



I have a form for allowing the user generate report with selection criteria.
This is a form with 5 Selection Fields - All of them combo-boxes. these fields passes the user selection parameters to a query, for generating the report.

Passing these combo boxes Values to the Query selection fields is easy; but I don't know how to handle the situation where the user did not select specific value in one filed or more.

I know I can use 'Is Null' in the query criteria in a specific column for the field - but then I have to make a very complex criteria, resulting in 5 * 5 situations (first field is null, 2-5 are not, second filed is null the others are not etc, etc.)

any suggestions?

[Rixxe]

Not sure if i totally get what you are saying, but if they don't put something into a Textbox, so the result is "" (empty), you then link it to a field in a query so:
Where TableA.FieldA = TextBox.Text

Or something similar, wouldn't it just pick up records where that FieldA is empty?

Or another option, however i'm not sure how easy it would be, is to convert a "" to a NULL. Maybe not convert, but update for example. In this case you could create a query using IF - THEN -ELSE.

IF textbox is NULL
Then Change it and run query.
Else
Run query normally.

Hope this helps somewhat. Good Luck.


Edit: Can you not set the combobox to be NULL by default?