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

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
 
M

Marshall Barton

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.


In the combo box's AfterUpdate event procedure:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top