combo boxes

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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
 
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.
 
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"
 
Back
Top