Control Source Linked to Code

[kcmark]

I have a form that pulls variables from a table, performes a fairly complex calculation and then inputs the results for each line item on a continuous form. The calculation is too complex to create directly in the Control Source property. I have written code that performs the calculation correctly, but I cannot figure out how to link the control source to the code I wrote. Any ideas?

 

[PHV]

Set the ControlSource property to something like:
=YourPublicFunction(parameter list)

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kcmark]

I could not get this to work, but I found a workaround by changing the formula so it would work with the ControlSource property. Thanks for your help!