Calculators + combos

[Sean_Sean]

I have 2 combo-boxes, first the user must select a value out of the first one and the something out of the second one. In the second one i want the price to be there but so the user cannot see it so that when they select something they are also selecting the price colomn that i can use a text box to do simple calculaton of multiplying it with another text box.

How can i do this?

 

[Pat Hartman]

Include the price column in the query used as the rowsource for the second combo. Then in the combo's AfterUpdate event:

Me.txtResult = Me.SecondCombo.Column(1) * Me.SomeOtherField

The columns of the combo's rowsource are a zero based array. So .Column(1) is actually the second column in the query. If price is not the second column, adjust the column index accordingly.

 

[Sean_Sean]

What does the "someotherfield" refer to?

 

[Sean_Sean]

sorry you mis-understood:
The drop-down arrow contains a hidden column, in one text box (called totadults) i want to end up with a price by multiplying another text box by the hidden colomn of the drop-down arrow.

 

[Sean_Sean]

Any other help? The above doesn't seem to work.

 

[David R]

Set the width of the Price column of your combo box to 0. It should become effectively invisible then.

It'll probably be something like 0;1.78;0 in the properties.

HTH,
David R

 

[Pat Hartman]

Does this make it clearer?

Me.totadults = Me.SecondCombo.Column(1) * Me.[another text box]

 

[Sean_Sean]

Yeah it has thanks