Combo set to first record when form opens

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah - 27 Feb 2007 22:37 GMT

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

Reply to this Message

Al Campagna - 28 Feb 2007 01:59 GMT

Sarah,
Set the combobox's DefaultValue to
=[cboComboBoxName].[ItemData](0)

Signature

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."

>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

Reply to this Message