Canned formulas for users to select from combobox

[jkirkland]

I have a table with canned formulas such as: (FldA + FldB)/FldB

I want the user to be able to select one of these from a combobox and then have this become a formula in my master query.

Unfortunately, I can only get the query to display (FldA + FldB)/FldB instead of this formula's result which should be a number.

My SQL shows: forms!myform!mytextbox as ColA

Any recommendations on how to make the query take the string from the text box and recognize it as a formula?

Let me know if I didn't provide enough details
Thanks!

 

[earthandfire]

Something very similar was discussed a week or so ago - I can't remember which forum or which thread, but I'm 99% certain it was Access.

 

[earthandfire]

I've found the thread:

thread705-1054925

It may be of some help.

 

[jkirkland]

I gave the eval() function a try, as mentioned in the thread you suggested, but I end up with the same result of the query reading "(FldA + FldB)/FldB" instead of the result of that formula.

My eval() statement was:
Eval("forms!myform!mytextbox") as ColA

mytextbox on myform has a value of: (FldA + FldB)/FldB

Any additional help is appreciated.