reset combobox value to default

[simian336]

I have several comboboxes on a form. Once I insert my current fields in the table I need to reset the comboboxes to their default values so the user can process the next entry.

I tried

Me.EMPLOYEE_ID.Value = Me.EMPLOYEE_ID.DefaultValue

but that just makes it equal to "Me.EMPLOYEE_ID.DefaultValue"

Thanks for the help!

Simi

 

[simian336]

Should have mentioned that the comboboxes are based on a query and the default value is set like [PERFORMED_BY].ItemData(0)

Simi

 

[simian336]

Not sure if I did it the most efficient way but I created public variables. Then I saved the defaultvalue to the public variable on form load. Then on update I reset the value to the public variable.

Simi

 

[MacroScope]

I'm sort of lost. You're using a form to input data to a table, right? Once you've entered whatever data you want to the form (and through it to the table), all you should need to do is go to a new record and the default values will reappear.

What's the problem? Why do you have to reset anything?