Open combo box to specific record

#1 (**permalink**) 28-Jul-2006, 08:31 AM

i have a combo box on an edit only form that i am using, i would like for
that combo box to start out on a specific record every time that i open my
form, anyone have any ideas on how to do this? Thank you in advance.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12767-open-combo-box-to-specific-record.html

*

#2 (**permalink**) 28-Jul-2006, 08:31 AM

Add a new field to your source data and sort on it descending. Put and "X"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12767
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12767
in the field.

"Economics" wrote:

> i have a combo box on an edit only form that i am using, i would like for
> that combo box to start out on a specific record every time that i open my
> form, anyone have any ideas on how to do this? Thank you in advance.

#3 (**permalink**) 28-Jul-2006, 08:31 AM

Economics wrote:
> i have a combo box on an edit only form that i am using, i would like
> for that combo box to start out on a specific record every time that
> i open my form, anyone have any ideas on how to do this? Thank you in
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12767
> advance.

ComboBoxes don't have "records". Do you mean you want its value to default
to a specific ROW in its RowSource?

Is this a bound ComboBox? If it's bound then it is going to show whatever
value the current record has for that field. If it is not bound then just
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12767
set its DefaultValue property to whatever value you want.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

#4 (**permalink**) 28-Jul-2006, 08:31 AM

Im sorry but im not really following you, could you please elaborate on how
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12767
this would work, and the process?

"KARL DEWEY" wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12767
> Add a new field to your source data and sort on it descending. Put and "X"
> in the field.
>
> "Economics" wrote:
>
> > i have a combo box on an edit only form that i am using, i would like for
> > that combo box to start out on a specific record every time that i open my
> > form, anyone have any ideas on how to do this? Thank you in advance.

#5 (**permalink**) 28-Jul-2006, 08:31 AM

I say that if your ComboBox record source is a table then add another field
and place an X in that field for the record you want to display as the
default.

Then sort the record source by that field, descending, and your other field
ascending. The record with the X will always be at the top of the
display.

"Economics" wrote:

> Im sorry but im not really following you, could you please elaborate on how
> this would work, and the process?
>
> "KARL DEWEY" wrote:
>
> > Add a new field to your source data and sort on it descending. Put and "X"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12767
> > in the field.
> >
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12767
> > "Economics" wrote:
> >
> > > i have a combo box on an edit only form that i am using, i would like for
> > > that combo box to start out on a specific record every time that i open my
> > > form, anyone have any ideas on how to do this? Thank you in advance.