values from Combo box

  • Thread starter Thread starter Fie
  • Start date Start date
F

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
 
In the control source of the field No.meals you write

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