Simple database how to choose value from dropdown???

  • Thread starter Thread starter gus1339
  • Start date Start date
G

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
 
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
Click to expand...

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.
 
Back
Top