Combo set to first record when form opens

S

Sarah

I think this is easy, but I'm not sure how to do it. My form has a combobx
that pulls its values from a lookup table. When the form opens, I want the
combobx to be showing its first record already (without it having to be
selected). How can this be done?

thanks
 
A

Al Campagna

Sarah,
Set the combobox's DefaultValue to
=[cboComboBoxName].[ItemData](0)
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Top