1st item in combo box

[Heather]

Is there a way for a combo box to show the 1st item in
the list automatically without the user having to click
the arrow on a blank box?

Heather

 

[Wayne Morgan]

I'm assuming you're wanting this when you go to a new record. If so, set the
default value of the combo box to

[cboMyCombo].[Column](0,0)

Adjust the first 0 to be one less than the Bound Column property of the
combo box. The Bound Column property is one based and the Column property is
zero based.

 

[Heather]

Wayne, you are the best! I can't believe what a pain in
the *&! this default issue has been, but it works, and
now I'm done with this project!!!!

Thanks!

Heather

-----Original Message-----
I'm assuming you're wanting this when you go to a new record. If so, set the
default value of the combo box to

[cboMyCombo].[Column](0,0)

Adjust the first 0 to be one less than the Bound Column property of the
combo box. The Bound Column property is one based and the Column property is
zero based.

--
Wayne Morgan
MS Access MVP

Is there a way for a combo box to show the 1st item in
the list automatically without the user having to click
the arrow on a blank box?

Heather

.