New

C

Craig Pfaff

Hi,

I've got a book here to learn how to use Access 2002 and I'm not having much
luck, I've created a table and I've got a field that I want the user to be
able to have a drop down list of two choices, I want a default because that
one will be used about 90% of the time, but on occasion they will need to
select the other.

Thanks Craig
 
F

fredg

Hi,

I've got a book here to learn how to use Access 2002 and I'm not having much
luck, I've created a table and I've got a field that I want the user to be
able to have a drop down list of two choices, I want a default because that
one will be used about 90% of the time, but on occasion they will need to
select the other.

Thanks Craig
Click to expand...

1) The table should be used to store the data, not to input data, so
you really should not have a drop-down box as part of the table.

2) Use a Form for data entry.
On the form you can create your combo box with a value list of just
the 2 choices.
Set the Control Source property to the field in the table.
Set the Default Value of this combo box to whichever choice you wish.
Set the column widths property as needed.
 
Top