drop-down lists

P

peta

Can anyone out there please tell me how to create a "drop
down list" I have tried everything.
 
P

peta

-----Original Message-----
In Access there's a wizard that will do it for you. Just turn it on (the
little magic wand in the toolbox) in a form's design view.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access




.
Thank you Arvin. I managed to do that, now i can't work
Click to expand...
out how to enter my information. Would any be able to help
me please.
 
J

John Vinson

peta said:
Can anyone out there please tell me how to create a "drop
down list" I have tried everything.
Click to expand...

What have you tried? Are you working in a Form (good) or in a Table (not so
good)?

The magic term is "Combo Box" - that's what a dropdown list is called in
Access. If you create (or go into design mode on) a Form, you can click the
magic-wand icon on the toolbox, and then select the "Combo Box" tool. The
wizard will walk you through the steps of creating one on your form.

It's *possible* to put a combo box in a Table by using the Lookup Wizard,
but I'd really recommend that you NOT use this feature! Table datasheets are
very limited and should not be used for routine data entry; the Lookup Wizard
does a little bit to encourage you to do so anyway, but then causes far more
confusion than benefit. See http://www.mvps.org/access/lookupfields.htm for a
critique.

John W. Vinson/MVP
 
A

Arvin Meyer

peta said:
out how to enter my information. Would any be able to help
me please.
Click to expand...

Sure, but I'll need a bit more specific information. In general, you use a
combo box with a table or query as a rowsource, or you build a select
statement from a table or query.

You can also create a value list of items. That's usually done if you only
have a few items like Yes/No, Male/Femail, etc. that you want a combo
(dropdown) box for.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top