Setting a default value in a Combo Box

[hrabbit]

Hi again gurus,
I am hoping someone can help me set a default value in my drop down box to the first value that my recordset row source sql query returns. Right now I have to click on the box and select the first record in the list because the default is blank. Is there any way to do this?
Thank you!
Rebecca

 

[DES]

This could be accomplished by creating a query which finds the same data as the combo box and assigning it to a text box which is hidden. This query would have to be set to find the "First" by using the sigma button on the tool bar in the query's design view.

You could then set the default value for the combo box to equal the text box.

If you need a sample let me know.

DES