values from Combo box

[Fie]

right to gett the No. Pupils value from the combo box to be able to
do a calculation in another box in my form.. i have to refer to the
combo box's Column property. If the No. Pupils value is in the 3rd
column, you'd use:
Me.MyComboBox.Column(2)
(column numbers start at 0 for the Column property)


BUT...... where do i put this code???? i assum its in the box i want
the calculation to apear in but where about??? the calculation i want
to do is to get


possible no. meals = No. Pupils x No. Meals

how do i do this and where do i put the code....

i am blonde u know teee heee

HELP...!!!

Fie x

 

[Guest]

In the control source of the field No.meals you write

=[MyComboBox].Column(2) * [Number of meals TextBox]

 

[Fie]

cheers yer a star...


x