control sources

[oliver]

i have a combo box an when i select an item from it i want it to display the other information relating to that item. i edited the control source for them. it worked for one field (equipment NO.) but when i tried it for the others it just displayed the equipment NO. not the field it was meant to.

There are ten combo boxes with the names equipnm1-10. for some reason it works for the equipment name but not the serial NO. quantity or cost/day boxes. The form isn't related to a table or query as it is a sub-form only.

Can anyone help?

Thanks

 

[mir_99]

hi oliver !

you can do it like that
u should put the "columncount" property of the combobox to the number of fields you want the combobox to show
then in the "afterupdate" property of the combo box u should PUSH the values to the appropriate fields as:

ME.[EquipmntNoTextBox]= Me.Combobox.Columns(?)
the ? is the index no of the field EquipmentNo in the table
one thing u should note here as the combobox index is 0 based so if EquipmntNo is the Fourth field in a table then u will mention Combobox.Column(3) to get it.

check this if i am understanding u right then it will work for u

Imran