ComboBox First Record in table (1 Viewer)

[Anauz]

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

 

[Chris RR]

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

 

[Anauz]

didn't work, combobox is still blank

 

[Chris RR]

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

 

[Anauz]

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

 

[Chris RR]

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