combo boxes

[Bill]

Good afternoon all

I have a quick question. I have a combo populated with the results form a
query. All I want to accomplish is to have the very first combo box option
to be an empty element with the results fo the query to populate the list
starting at the second element possition.

Can anyone point me in the right direction for accomplishing this??

Thank

Bill

 

[Bill]

OMG

my typing is terrible today. Let me try again.

I have a quick question. I have a combo box populated with the results from
a query. All I want to accomplish is to have the very first combo box option
to be an empty element with the results from the query to populate the list
starting at the second element position.

Can anyone point me in the right direction for accomplishing this??

Thank

Bill

 

[Beetle]

You could use a Union query to add a blank row to your combo box. If
you post the SQL from the rowsource of your combo, someone should
be able to assist you in modifying it.

 

[Douglas J. Steele]

You'd have to add an additional empty row to the recordset returned by the
query, and make sure that the sort order is such that it appears at the top
of the list. This is similar to the technique used to add an "All" row to a
combo, as discussed in http://www.mvps.org/access/forms/frm0043.htm at "The
Access Web"

 

[Bill]

Brilliant. Thank you

Bill

You'd have to add an additional empty row to the recordset returned by the
query, and make sure that the sort order is such that it appears at the
top of the list. This is similar to the technique used to add an "All" row
to a combo, as discussed in http://www.mvps.org/access/forms/frm0043.htm
at "The Access Web"