Combo Box continuous selections

[Jerri]

Is it possible when using a combo box to be able to select a selection and
then have that selection already choosen for the next data entry form? For
example, I am creating a serial number database. The user choose the model
and then enter the serial number. Say they have several of the same model to
enter. Is it possible to select a cyclone device and then on the next data
entry form have the cyclone device already choosen without the user entering
it again?

Thanks

 

[Rick Brandt]

Is it possible when using a combo box to be able to select a
selection and then have that selection already choosen for the next
data entry form? For example, I am creating a serial number database.
The user choose the model and then enter the serial number. Say they
have several of the same model to enter. Is it possible to select a
cyclone device and then on the next data entry form have the cyclone
device already choosen without the user entering it again?

Thanks

In the AfterUpdate event of the [Model] ComboBox...

Me.ComboBoxName.DefaultValue = Me.ComboBoxName

This will not persist between sessions of the Form, but will work as you move
from record to record per-session. It also will not work reliably in a
continuous form or datasheet form because the "New Row" will be displayed and
the default values populated before you have made your first entry. If you had
to do more than a couple rows with the same value it would still have some
benefit, but you would have to watch the default value carefully any time you
changed.