Default value on a drop down menu

N

Natalie

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?
 
J

Jeff Boyce

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
 
Top