Add Null Value to Combo Box

[mvlt]

I am using Access 2003 and working on a query by form. I have a form with two unbound combo boxes. The form searches our contact list for people in a certain renewal cycle. It then gives the option of looking for a certain constituency within that group.

The first combo box, cboRenewalCycle, lets the user select from a list of Cycles (FEB, JUN, SEP). The second, cboConstituent, lets the user select from a list of Constituents (Business, Foundation, Partner). The constituent field resides on the tblJoinAddress, but each contact does not have the field filled in. The combo box, cboConstituent draws its values from tblREF_Constituent. Item 1 in that table is a blank field, and I thought that would take care of it.

I would like to add a null value to the combo box, so that the user can just pick a cycle if they want, and they don't have to do anything with the Constituent combo box. Essentially I would like to add a null value to the box.

Any suggestions?

Can I also add a select all option?

[MMcCarthy]

I am using Access 2003 and working on a query by form. I have a form with two unbound combo boxes. The form searches our contact list for people in a certain renewal cycle. It then gives the option of looking for a certain constituency within that group.

The first combo box, cboRenewalCycle, lets the user select from a list of Cycles (FEB, JUN, SEP). The second, cboConstituent, lets the user select from a list of Constituents (Business, Foundation, Partner). The constituent field resides on the tblJoinAddress, but each contact does not have the field filled in. The combo box, cboConstituent draws its values from tblREF_Constituent. Item 1 in that table is a blank field, and I thought that would take care of it.

I would like to add a null value to the combo box, so that the user can just pick a cycle if they want, and they don't have to do anything with the Constituent combo box. Essentially I would like to add a null value to the box.

Any suggestions?

Can I also add a select all option?

What is the current row source of cboConstituent?

[JConsulting]

>>The constituent field resides on the tblJoinAddress, but each contact does not have the field filled in.

Use this for the rowsource for your combo box. It will add an All option and a "blank" option, along with your list of constituents.

Select '<All>' as constituent from tblJoinAddress
union
Select Null as constituent from tblJoinAddress
union all
Select distinct Constituent from tblJoinAddress
order by constituent;

J