MS Access Text Box Control

[Brian]

This has been perplexing me for quite some time now and I can't seem
to figure it out. I have a form with a number of unbound text boxes
with equations in them. Some of these text box equations are based on
other text box equation results (one equation calculates a motor
current and the next one calculates a motor voltage based on that
current). It is important that, for this example, the motor current
gets calculated first. How can I make sure this happens as it doesn't
seem to be working right now.

Any help you could give me would be appreciated.

 

[Jim Bunton]

While it doesn't answer the fundamental question in your posting, one thing
you might try is writing a function and using that in your query.
This way you can control the order of computation. eg SELECT
MotorVoltage(field values) From yourTable

Thus you may have a function

Function MotorVoltage(argument list)
dim current as long
current = MotorCurrent(argument List)
'rest of calculation
end function

and another function

Function MotorCurrent(argument List)
'calculation
End Function

Jim Bunton