Default value on a drop down menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that I use to track purchases made through our company. I have
a field named account codes that is a drop down box that displays all of the
account codes available. 99% of the time, we use the same account code so I
would like this to be the default value in the menu. When I tried to use the
default value property in the properties, it didn't do anything. Any
suggestions?
 
Natalie

If your combo box on your form is of standard design, AND if the field
underlying the combo box is NOT a "lookup" data type field, then you'll need
to use the AccountCodeID, rather than the displayed value, for the Default
value/property.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top