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