Calculations on Form

[BarkingPig]

I can barely follow most other threads so I hope I can explain my problem and what I need help with.

I'm currently creating an Access form so that I can more easily take property appraisal orders. I'm pretty proud of my form so far but cannot figure out how to calculate certain combo boxes:

I have three combo boxes which are basically what is used to determine what the order will be. 1st combo box is the actual product selection. 2nd combo box is a selection for an additional form to the base product type. 3rd combo box is a modifier...if value is greater than X, then modified by X dollars. The first two combo boxes already have tables created which lists the key, then the product type, then the actual price. However, on my form I only show the 2nd column of the table, the product type. I'd like a way to have so that as someone inputs the data and selects an appraisal type, that the fees are calculated and then appear on the actual order form somewhere without having to print any reports or invoice reports. Any suggestions?

Oh yeah, I kept trying to use the Limited Combo Box but I kept getting an error message that wouldn't go away and I'd have to alt-tab-del out.

-Steven

 

[naygl]

There are a few ways that I am aware of. The one I use is to create a combo box with two columns, one with the product name and one with the price. you the set the column width of the price column to 0cm so it doesn't show up. To refer to it in a calculation, and store the number somewhere,you would type:
Text1 = Me.Combo1.Column(1) * Combo3(or something like that)
PS The first column in a combo box is Column(0).
HTH.

[This message has been edited by naygl (edited 02-14-2002).]