Basic Question

[chris11590]

Should the countrol source be different when you have several combo boxes and you are trying to display a different record for each individal combo box . Do i have to put a function procedure in the default value or am i doing something wrong?

 

[Rabbie]

Should the countrol source be different when you have several combo boxes and you are trying to display a different record for each individal combo box . Do i have to put a function procedure in the default value or am i doing something wrong?

The control source will depend on what it is you want to display in the combo box. The default value does not need to be a function procedure. It could for example be a constant.

In order to give you a more detailed answer you will need to give a little more information about what you are trying to achieve

 

[chris11590]

i have created a row of combo boxes and when i try to select a record they automatically change the record in the other combo boxes and then what i see is the same record in all the boxes. i created it by coping and pasting would this have anything to do with it. they are all bounded. the only time they have the same record is when they are not bounded. but then what happens next is when i close the form. all data i selected lost.

 

[The_Doc_Man]

In general, this is correct behavior of the product. The mismatch is in your expectations. A form is normally bound to a single underlying recordset because there is only one slot on the form's properties list for that recordset to be identified.

If you are trying to enter multiple data elements from multiple records in drop-downs, I'm thinking that you are trying to establish relationships between one record and multiple others. But that's one man's impression from a quick read. If it is wrong, that shows you how unclear your description was.

How about telling us what you were trying to DO with the multiple combo boxes.

 

[neileg]

I would expect that each combo would be based on a different data source, probably a query.

 

[chris11590]

i apologize for the unclear description, but i am a novice at this. i ll try one more time. when i select a record from the drop down list, the rest of the combox boxes i created, by pasting and copying, will show the same record i select from the first combo box. for example, the drop box is a list of employess, when i select employee "a" on the first box, the rest of the combo boxes will now show employee "a"automatically. i would like to select employee "a" for the first combo box and employee "b" for the second combo box and so on. i hope this helped.

 

[chris11590]

it is based off a query.

 

[neileg]

If you have 5 combos you need 5 queries. If you have 5 combos and one query, you will always see the same record in each combo.