Calculator

[Sean_Sean]

I have got two drop-down arrows and on the 2nd one i would like it contain a field that the user did not see that i could then use to do a calculation. For example prices of a attraction's enterance fee is hidden in the drop-down arrow when the user enters how many adults and children there are it finds the hidden fields: Price and works out the total.
Any ideas?

 

[Jack Cowley]

Create your Combo boxes using the Wizard. This will let you hide the field you want. In your code to do your calculations refer to the combo boxes like this to get the selected value: Me![ComboboxName].Column(0)
The code above assumes the hidden field is the first column in the Combo box.

[This message has been edited by Jack Cowley (edited 02-03-2002).]