Hi Guys
I cant seem to get my head around this problem
this is the query that I need to amend, currently it works really well and updates the "reelweight" with the value entered on the form "frmTestSheetEnterTestResults"
Code:
UPDATE tblTestsResults SET tblTestsResults.ReelWeight = [Forms]![frmTestSheetEnterTestResults]![ReelWeightHeaderTXTBox], tblTestsResults.MachineName = [Forms]![frmTestSheetEnterTestResults]![MachineNameHeaderTXTBox], tblTestsResults.TestType = "ENTER IIF HERE"
WHERE (((tblTestsResults.ReelWeight) Is Null) AND ((tblTestsResults.ProductionOrderID)=[forms]![frmTestSheetEnterTestResults]![ProductionOrderID]) AND ((tblTestsResults.TestSheetID)=[Forms]![frmTestSheetEnterTestResults]![TestSheetID]) AND ((tblTestsResults.ReelNumber)=[forms]![frmTestSheetEnterTestResults]![ReelNumber]));
what I need to do now is update the tblTestsResults.TestType with either "Scrap" or "Prime" depending on a checkbox "Checkbox99" being clicked on the form "frmTestSheetEnterTestResults"
if the checkbox is clicked, I need to update the "Testtype" field to "Scrap" and if it's not the update "testtype" field to "Prime"
I hope this makes sense I just cant seem to get my head around this
any help would be great
many thanks
steve