Drop Down Combo box help

[vince99]

Lets say you have a table and you want to build a combo box on a form. Can you select which fileds from the table are displayed in the drop down combo box ?

If so can you please post an example?

Thanks in advanced

 

[ghubbell]

Morning Vince,
You say you have a table so here's all the steps you need:

Place your form in design view. Make sure the wizard button (wand & stars) is depressed on your form design tool bar.
Click on the button for combobox. Drag out the shape of the combo on your form. The wizard should start at this moment.
Choose that you want to look up data from a table, then select the table where you want to get the data. You'll be asked which fields you want in the combo. Pick your fields. (Pointer: Its a really good idea to choose the tables records "ID Number" field first). If you use this little pointer Access may automatically hide this key field for you. (show it or not, as you choose.) You can size any of the columns to the widths you feel are appropriate for your use. If you've done this on a form that is based off of a table or "the table", you can choose to either remember the value for use at a later time, or store the value in a field from the forms table. I don't know what your plan is with the combo so you'll have to pick this one on your own. (Storing for later use means it is Unbound and you can change or pick whats in the combo, and nothing happens unless you write some code to have it say, search for the value in the combo, or, filter for the value in the combo. If you make the combo "Bound" to a field, if you change "Smith" to "Jones", the forms underlying record will have its field changed.) Your finally asked what label do you want for the combo (this is the label beside it i.e.: "Orders&quot. Enter in something or take what it automatically gives. Click finish. Your combo is done! You can now play with its size, move it around, make it raised, sunken you name it. Don't like it? Delete it and do it again. That's it Vince! Gord
ghubbell@total.net

 

[vince99]

Thanks for the info.

Is there any way of selecting which cells of a particular column you want in the combo box?

Thanks in advanced.

 

[jfhewitt]

There are two ways to accomplish what you want. 1. Create your table for the combo box (easiest if not too many fields). Otherwise, base your combo box on a query, and select your records in the query.