Simple database how to choose value from dropdown???

[gus1339]

This seems like it should be simple. I have student database and want
to be able to maek the class field a dropdown and be abnle to choose
the class???? How do I do this?

UniqueID: 1
Name: John Smith
Class: Freshman (want to be able to have a dropdown and choose from
freshman, sophomore, junior, senior)

UniqueID: 2
Name: Mary Brown
Class: Choose from dropdown list

UniqueID: 3
Name: Joe Smoe
Class: Choose from dropdown list

UniqueID: 4
Name: Sue Smith
Class: Choose from dropdown list

 

[croberts]

This seems like it should be simple. I have student database and want
to be able to maek the class field a dropdown and be abnle to choose
the class???? How do I do this?

UniqueID: 1
Name: John Smith
Class: Freshman  (want to be able to have a dropdown and choose from
freshman, sophomore, junior, senior)

UniqueID: 2
Name: Mary Brown
Class: Choose from dropdown list

UniqueID: 3
Name: Joe Smoe
Class: Choose from dropdown list

UniqueID: 4
Name: Sue Smith
Class: Choose from dropdown list

On your form, you have a textbox for the class field. Right click it
and select Change To--> Combo Box. In the properties for the Combo
Box, make the Row Source Type: Value List. Type "Freshman";"Sophmore"
etc. in the Row Source.

 

[gus1339]

Thank you! Thank you!!!!