Forms question

[jnh]

Action:
User keys data into a Form Control which triggers a VBA event procedure call.
The VBA event uses value of user input to perform several calculations. Result
of each calculation in then placed into proper control (me.NumA = result1
me.NumB = result2....) during the VBA call.

Problem:
Values for calculated controls (NumA, NumB..) do not display on form
in their designated places. Please note that the controls containing the calculated fiels are coded as NOT enabled (but visible).
I know the values are properly placed into table because if I reprocess form all the previous calculated data displays correctly (before user even has a chance to perform any entry action)

Any help is highly appreciated...jnh

 

[jzwp22]

I know the values are properly placed into table because if I reprocess form all the previous calculated data displays correctly (before user even has a chance to perform any entry action)

In general, calculated values should not be stored in the table only the raw data used to calculate them. Calculations should be done on the fly when needed in forms, queries and reports.

Just for test purposes, if you enable the controls do the values populate correctly?

If you do not store the values, you do not have to worry about the enabling or locking the controls

By the way, on what event are the actions being triggered?