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
-----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
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.
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
