Default value for combo box

[spottednewt]

I am trying to set the default value of a combobox in a form to be the previous record's value. I used the following code under the Got Focus Event with numeric fields and it worked just fine.

Me.numeric_field.DefaultValue = Me.numeric-field.Value

But when I try to set the default value of the combo box this way, or in any way other than typing the actual value into the default box under properties, I get a #Name? error.

The combo box is a text field with two lookup values.

Any ideas as to what I'm doing wrong?

 

[MajP]

Should work. If it is a text field though you may need to add parentheses

Me.cmboSelect.defaultValue = "'" & Me.txtBxValue & "'