Making the last value entered the default value in a combo box

  • Thread starter Thread starter Degger
  • Start date Start date
D

Degger

I'm creating a relatively simple database that will
require a lot of input...

Is there a simple way to set the default values of
certain combo boxes so that they retain the last value
entered?

For instance, the form lets you input data about baseball
players, however, the team combo box rarely changes... I
only want to change it when I switch to a new team.

When I switch to a new team, I want it to stay on that
team until I switch again.

Thanks in advance
 
Degger said:
I'm creating a relatively simple database that will
require a lot of input...

Is there a simple way to set the default values of
certain combo boxes so that they retain the last value
entered?

For instance, the form lets you input data about baseball
players, however, the team combo box rarely changes... I
only want to change it when I switch to a new team.

When I switch to a new team, I want it to stay on that
team until I switch again.
Click to expand...


In the combo box's AfterUpdate event procedure:

Me.combo1.DefaultValue = """" & Me.combo1.Value & """"
 
Back
Top