MS Access Text Box Control

  • Thread starter Thread starter Brian
  • Start date Start date
B

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.
 
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
 
Back
Top