Default value set after update until user changes it again

[BarbaraH.]

I have a combo box with a list of values.
After the user selects a value from the list I want to set
the default value to that value. All records they enter
from that point on should have the value they selected.

Once they select a different value via the pulldown, I
want the default value reset to their new choice. This
then becomes the default value until they change it again.

Thanks,
bh

 

[Andy Cole]

Barbara

Add the following to the Combo's AfterUpdate event;

Me.comboName.DefaultValue = Chr(34) & Me.ComboName & Chr(34)

HTH

Andy

 

[JanetC]

Hi Barbara,

I have to do something very similar with a form I'm
working on. Just wondering if you found a solution yet?
Or if you could share it if you find one soon.

Tks,

Janet