I want to be able to display first record in my table in the combobox rather than a blank field. I don't want to put in a default value in the properites box because it is sorted Alphabetically....and something could replace it as the first later on. Any ideas?


Thanx in advance

Try "is not null" in the criteria of the query for your combo box.

didn't work, combobox is still blank

Let me back up & ask, is your combo box based on a query?

no a table....sorry should have said that.

You might then try basing the combo box on a query of that table.