Data calculated on forms not transferring back to Tables

[gemma-the-husky]

david

without checking, i've probably done something similar to bob

i've added greyed textboxes to your form ASK to store the calcs, so you can see what's happening

I also based the form on a query so you can see the patient name,
and as bob said changed the stored scores to double rather than long datatype so they store the calc's properly.

i'm updating the stored calcs inthe form before update event. Look at the code behind the form ASK.

View attachment DatabaseDG.zip

 

[boblarson]

good tag team effort gemma!

 

[DavidGr]

cheers you guys

thanks a lot for the help, i'm just trying to locate the code you put in so and where so I can do the same again!

I really appreciate it