IF then Else in Macro After insert (table)

[alta563]

This is sample what I did..I just want to insert category of BMI when user enter the value of BMI. Then in another column they will stored automatically the value such as "obese" or "normal"





When i run the form and enter the value an error occur.

"A data macro resource limit was hit.
This may be caused by a data macro recursively calling itself.
The Updated(<Field>) function may be used to detect which field in a record has been
updated to help prevent recursive calls"



then in my table display this repeating although the value displayed not correct





please help me...i'm stuck here, and i am really a beginner in access....pleasee, thank u

[alta563]

anyone??? please...its access 2010

[Dunro]

This is sample what I did..I just want to insert category of BMI when user enter the value of BMI. Then in another column they will stored automatically the value such as "obese" or "normal"

Unfortunately, I'm not sure why you're having that error (based on what you've provided).

That being said, you could also use a query to display Obese I, II, III, etc. based on each BMI value. This also saves having to change all of your data should the definition of Obese ever change, etc.