If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Simple database how to choose value from dropdown???
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 |
#2
|
|||
|
|||
Simple database how to choose value from dropdown???
On Sep 12, 9:48*pm, gus1339 wrote:
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. |
#3
|
|||
|
|||
Simple database how to choose value from dropdown???
Thank you! Thank you!!!!
|
Thread Tools | |
Display Modes | |
|
|