Combo set to first record when form opens

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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."
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
How to set different combo box values for new record? 6
Using combo box when adding records to continuous form 1
Using Combo Box to select records for update 1
Default value on continuous form from query 2
Combo opening in a blank record 1
Combo Box, select Station, opens new form to specified record 5
Open form with specific record, but other records accessible 11

Back
Top