Combo Boxes

[chris11590]

when i select from the drop list of my bounded combo boxes, all the combo box switch to the same selection. when i had intially created the form , i copied and pasted all the combo boxes. can anyone, plz offer a solution. my control sources are all the same and are related to a table not a query.

can anyone tell me what the bound column in the properties listing is for???

 

[DCrake]

Simple Software Solutions

Your initial question is somewhat nondescript please elaborate. However, with regard to the second question the bound column works thus:-

Say you have a table with a code and description and your combo box displays the description but you want to store the code in your table for the item selected from the list. You may choose to hide the column that contains the code

ColumnCount = 2
ColumnWidths = 0cm,3cm
BoundColumn 1

Your code will be in column 1
Your description will be in column 2
As you have hidden column 1 the user will only see the description, but the value you save in the field is column 1 - the code.

There are lots more things you can do with combo boxes but I think this answers your question in its purest form.

CodeMaster:

 

[chris11590]

wow, im a novice. i guess when the time comes, i ll look at how to make codes. thank you.

question 1, i created a row of combo boxes under one another by coping and pasting the first combo boxes. unfortunately, two things occur that may be as a result of copy and past. when i in form view and i select a record, the record is all automatically and changed with the rest of the combo boxes under one another. the control source is to a table and is unbounded. hope this helps very fustrated.