DefaultValue for ComboBox

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

AfterUpdate event:
Me!txtX.DefaultValue = """" & Me!txtX & """"

The above works great, but didn't seem to work for a combo
box....anyone???
 
-----Original Message-----
AfterUpdate event:
Me!txtX.DefaultValue = """" & Me!txtX & """"

The above works great, but didn't seem to work for a combo
box....anyone???

I tried:

Me.cboSelectAName.DefaultValue = Me.SelectAName

in the AfterUpdate event of the cboWhatever, and it worked
fine. When I go to a new record, the default value in the
comb-box is the one from the previous record.

"SelectAName" on the right side of the equation is the
Control Source for cboSelectAName (the field where the
selected value from the combo-box is stored).

-Amit
 
Oops, caught a small error. Here's the correct version:
=======================================================
I tried:

Me.cboSelectAName.DefaultValue = Me.SelectAName

in the AfterUpdate event of the cboSelectAName, and it
worked fine. When I go to a new record, the default value
in the combo-box is the one from the previous record.

"SelectAName" on the right side of the equation is the
Control Source for cboSelectAName (the field where the
selected value from the combo-box is stored).
 
Back
Top