Let's step back and think about this. I would think you would have two tables: a reference or look up table and a table of actual crimps.
The reference/look up table would have fields
tblWireGauges
=============
WireGaugeID_PK (autonumber)
Gauge (Text)
AWGStandard (Text)
CrimpHeightLo (Double)
CrimpHeightHi (Double)
tblCrimps
===================
CrimpID_PK (Autonumber)
CrimpNum (Text)
Gauge (Text)
CrimpHeight (Double)
I would write a UDF to determine if the crimp height is within tolerances.
The form record source is a query
Code:
SELECT CrimpNum, Gauge, CrimpHeight, fnInTolerance(Gauge, CrimpHeight) as Tolerance
FROM tblCrimps
(fnInTolerance is the name of the UDF)
I would set the form to continuous forms view. 4 text boxes would display the data.
Do you have a dB already?