ms access - field dropbox

[chipy]

hi all

i'm wanting to put a dropbox with a few options for one of the fields in my MS Access database table. does anyone know how to do that?

e.g. there's a field called "supervisors". i want a dropbox with choices for Mr. Goodwin, Mrs. Talon, and Mr. Fellow. that way someone can't just type in a nonsense answer like Mr. mumbojumbotheresnosuchperson.

thanks
chipy

 

[KLin]

It's called a combo box. You create a table, input those names into said table, then set the source of the combo box list to that table. There's an option in the properties of the combo box to limit the selections to only those in the combox box list.

 

[chipy]

thanks KLin - i'll give it a shot

chipy

 

[chipy]

Thanks Klin - it worked!

i just have one more question... what's the diff between combo boxes and list boxes?

chipy

 

[KLin]

Originally posted by: chipy
Thanks Klin - it worked!

i just have one more question... what's the diff between combo boxes and list boxes?

chipy

You could have used a list box too. A list box only lets you select from the list. A combo box lets you type within it. But you can still limit the input to the source data of the combo box.