Combo Box continuous selections

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerri - 25 Mar 2005 16:09 GMT

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

Reply to this Message

Rick Brandt - 25 Mar 2005 16:47 GMT

> 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
[quoted text clipped - 5 lines]
>
> 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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message