Good day all
I have a form to which I enter data like Height, Weight, Waist etc. Once a week a member is weighed and measured and that information is captured in the form. So there can be many entries for just one person. What I want to do is every time the new data is entered, for instance the weight, it must check the previous weight of that member and indicate if that member lost (Image1), gained (Image2) weight or stayed the same (Image3) by enabling one of three images. To identify a member I use a [paynumber] field. It must just use the last record for the [paynumber] field on the form. The form is called frm_ef_memberfitness. The primary key is [memberfitnessID].
I hope this helps and makes sense.
Bookmarks