Newbie

[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

 

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

 

[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

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