save min value between 3 fields on a form not a table

[Blair168412]

the 3 fields are s-1, s-2, s-3 all have the same properties numbers and I
want to find the minimum value ans stote it in MinVal field from one record
on a form

 

[Jeff Boyce]

If you can 'calculate' the minimum, don't bother storing it in a table!
After all, if someone makes a change (correcting an error, making an error,
whatever), your stored "minimum" would then be out of sync!

Instead, use a query (or the form) to calculate the minimum on-the-fly, for
display purposes.

Regards

Jeff Boyce
Microsoft Office/Access MVP