Newbie

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
 
J

Jeff Boyce

Craig

If you will (almost certainly) only ever have two choices, another approach
would be to use a radio button group and set the default to the most common
choice.
 
J

John Vinson

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...

First off.. DON'T use table datasheets routinely for data entry. They
are of VERY limited capability; and putting combo boxes into a Table
has disadvantages. See http://www.mvps.org/access/lookupfields.htm for
a critique.

Instead, use a Form. You can put a combo box on the Form with a List
of Values (just two of them at present); you can set its Default
property to one of them, by setting the Default property of the combo
box control in form design view.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top