Open combo box to specific record

[Guest]

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.

 

[Guest]

Add a new field to your source data and sort on it descending. Put and "X"
in the field.

 

[Rick Brandt]

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.

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
set its DefaultValue property to whatever value you want.

 

[Guest]

Im sorry but im not really following you, could you please elaborate on how
this would work, and the process?

 

[Guest]

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.