My First Datebase

[Hackney]

My First Database

Hi all.

I need to make a database for work.

I used Access many years ago but have forgotten most of what I knew.

I want to make a form for entering data into the table.

For one of my fields I would like the user to only be able to make a selection from a pre-defined list but I would like them to make more than one selection if required.

Example:
Languages:
English
French
Spanish

From that they could choose more than one.

How would I go about doing this.

Would it be done at the form stage?

Thanks.

 

[statsman]

Sounds like an ideal use for a combo box.
Make a new table called languages which contains the languages you want. On your form make a combo box which is connected to the lanuage field in your underlying table. Click on the combo box, highlight the language and it will be saved in the field.

 

[Hackney]

But doesnt a combo box only let you make one selection?

 

[neileg]

Do a search on multi select

 

[Hackney]

I'd rather have check boxes or even radio buttons to be honest.

Is this not possible?