Combo Box - display first result 2

[lachesis]

Its probably staring me in the face but I can't see the wood for the trees at the moment.

Ive got a combo box on a form that creates a list from a table when the form is opened. I want the combo box to display the first record it retrieves when the form opens, instead of a blank.

I know this is easy but i dont use Access on a regular basis. thnx

L.

 

[wizcow]

lachesis

You should be able to enter
1
in the 'Default Value'

Tom

 

[danvlas]

This should do the trick:

ComboName = ComboName.Column(1, 1)

Good luck

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[lachesis]

Did I mention the combo box is unbound.

wizcow - your suggestion just returns '1', not the first record in the list.

dan - what control field should I add this function to??

L.

 

[danvlas]

"I want the combo box to display the first record it retrieves when the form opens"

Use the Load event of the form:

Sub Form_Load()
ComboName = ComboName.Column(1, 1)
End Sub

Change ComboName to the exact name of the combo box on your form and...voila...

Good luck


Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[lachesis]

Thanks dan. works like a dream

L.