RE: combo box default selection

Tech-Archive recommends: Fix windows errors by optimizing your registry

I've done that but it is still select the first value in the first row of the
table rather than the first value in the list which has been sorted
alphabetically.

"Klatuu" wrote:

> Put it in the default value property of the combo box.
>
> "Kevin R" wrote:
>
> > Sorry I'm new to Access so I may need a little more help. For my RowSource
> > this is what I have now:
> >
> > SELECT tblOfficeInfo.OfficeName FROM tblOfficeInfo ORDER BY
> > tblOfficeInfo.OfficeName;
> >
> > If I look at the SQL View it shows:
> >
> > SELECT tblOfficeInfo.OfficeName
> > FROM tblOfficeInfo
> > ORDER BY tblOfficeInfo.OfficeName;
> >
> > So where do I fit your line in at?? Thanks.
> >
> > "Klatuu" wrote:
> >
> > > Me.cboMyCombo.ListIndex = 0
> > >
> > > "Kevin R" wrote:
> > >
> > > > I have a form with a combo box on it that is populated with items from
> > > > another table. I have it so that it is sorted alphabetically but rather than
> > > > the first item in the list being selected as the default choice, it select
> > > > the first item I entered into the table as the default selection. How do I
> > > > make it always default to the first item in the combo list?
> > > >
> > > > thanks.
.