all the fields (except for wl_effective and wr_effective) are populated after the user makes a selection in two combo boxes. From there, the wl_effective and the wr_effective are calculated using the equations wl-OSB and wr-OSB respectively (which i have working).
What i need though, is help in calculating the above formula. Im not sure if it is possible by using an equation, or it if have to calculate each individual element first in VB then apply the Square Root to it.
If anyone can give me some assistance with this I would really appreciate it as it's the last thing i have to do to complete the functionality of this part of the database.
you should create a function to perform the calculation. Something like:
Public ComplicatedFunction(dl as double, wl as double, dr as double, wr as double, OLD as double, s as double, ERD as double , OSB as double, ISO as double, wl_effective as double ,wr_effective as double) as double
ok, im getting an error message when using your code. on the Public calculate(dl as double, wl as double, dr as double, wr as double, OLD as double, s as double, ERD as double , OSB as double, ISO as double, wl_effective as double ,wr_effective as double, combo39 as double, combo29 as double) line, it's highlighting the first As and saying "Syntax Error".
I have attached the database (an Access 97 one) so that you can see this message yourself.