add a drop down for a field in MS Access

mkramer777
mkramer777 used Ask the Experts™
on
I know nothing about Access but I know someone here does!  I have Access 2000 (stop laughing) and I want to do a simple task with it.  See screenshot.  I need to design a field on a form to have a drop down list that I can choose different entries from.  The field is "MAKE"

Can EE help me with this?
Screen-Shot-2019-03-14-at-12.01.06-P.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Application Developer
Commented:
Sure.  :)  Open the form in Design view, and right-click on the MAKE field.  Put your cursor on  "Change to...", and a context menu will appear to the right.  Chose "Combo Box".  That will change the format of the field.

After you've changed the format, double-click on the MAKE combo box to open the Properties window (if it's not already open).

If you want the field to display a list of values, click the Data tab, and in the RowSourceType, choose 'Value List'.  In the RowSource field, type the values, separated by semi-colons, you want the combo box to display.  If you want the field to display values from a table, in the RowSourceType, choose 'Table/Query'.  In the RowSource field, paste the SQL of a query that retrieves the values you want the combo box to display.

If you get stuck, let us know how far you got, and where you want to end up.  :)  Good Luck!

Author

Commented:
THANK YOU.  GOT IT!
Paul Cook-GilesSenior Application Developer

Commented:
Splendid.  Glad we could help.
Paul Cook-GilesSenior Application Developer

Commented:
Would you mark the answer 'accepted' and close the question, please?  Thanks!
PCG

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial