CODEWITHSUNDEEP
databasems-accessfieldoffice-2007
Crash893
Crash893

Reputation: 11702

make field a dropdown in access 2007

I'm creating a HR database in access 2007

I have a main table of employee info and several tables that relate to that table ( education for example) that list the acceptable elements that can populate that cell in that row

When i create a form it was created as just a plain text field which is constrained but I wanted to create a dropdown that had just the data that they are allowed to enter to avoid confusion.

Upvotes: 1

Views: 1125

Answers (2)

BenV
BenV

Reputation: 12452

You should be able to right-click the text box and select Change To -> Combo Box.

Upvotes: 1

Fionnuala
Fionnuala

Reputation: 91336

If you are not familiar with creating controls, it is best to use the wizards. Select a combobox from the toolbox and add it to your form, you will be guided through creating the type of combo that you want.

You should also examine the relationships you have created.

Upvotes: 1

Related Questions