drop down box data imported on to another field

[kabir_hussein]

hi i am trying to select an item from a drop down box and when i select the item i want the price of the item to appear on a sepearate field called price.

i have seen another database do the exact thing i want but on that occasion the address selected was imported into another table called ship address.

mine is very similar but i want the price to be imported to another field


can anyone help i will be very greatful

many thanks in advance

 

[dcx693]

If you use a multicolumn combo box and just make the item name visible, then you can have the price data in the same combo box. That is, put two columns in your combo box, but only make the first one visible. When the user selects the name from the box, code in the combo box's After Update event can place the price into that other field.

Every combo box has a .Column property. The first column is referred to as .Column(0), the next .Column(1). So assuming your combo box is called combo and the other field is called otherfield, this sample code for the After Update event would take the data in the 2nd column of the combo box and put it into the otherfield:
Me.otherfield=Me.combo.Column(1).

 

[kabir_hussein]

thank you

Hi

i just like to say thank you so much you have saved me alot of bother

thanks once again

 

[dcx693]

No problem. You're welcome.