Allow Null Value in Query??

[KristenD]

I have a form that is based off a query with combo boxes in order to choose what data is pulled.

I would like one of the combo boxes (for superintendents) to not have to have information in it so it will pull everything all the info OR be able to choose a specific superintendent.

I looked on the property sheet to see if I could choose null value allowed but I didn't see anything there under the Data tab. Is this possible or should I be looking at another tab for this info?

Thank you in advance!

 

[pr2-eugin]

Not sure how you want it to work, but I am guessing you have a ComboBox whihc has names of Superintendents either after selecting a name or clicking a button you want it to runa Query is this correct??

 

[KristenD]

Yes, I have 7 unbound combo boxes that tie back to the query in order to run the report. So 6 out of the 7 combo boxes (Emp Status, craft codes, skills and ratings) need to be filled out.

 

[pr2-eugin]

So in the Query where you take the value for the Last combo box check if it is zero length, if so include all; else only the ones that is selected.. Something like..

Like IIf(Len([Forms]![Your_form_Name]![Combo_Box_name] & "")<>0,[Forms]![Your_form_Name]![Combo_Box_name],"*")

The bit of code goes in the criteria..

 

[KristenD]

Thank you!! I think I understand!