Hey Experts!
I have three tables: tblMain, tblECOInfo, tblECRInfo
tblMain consists of: ECO# and ECR#
tblECOInfo consists of: ECO# and other fields
tblECRInfo consists of: ECR#, ECO# and other fields
The two ...Info tables are linked to tblMain respectively.
The problem:
When, in a form, the user clicks a button that calls an append query to send the ECO# currently displayed on the form (recordset from tblECRInfo) to tblECOInfo it prompts for a Parameter Value...
The same thing happens for my update query, which fires after the append query...
What is the issue with my coding??? Exact examples listed below...
INSERT INTO tblECOInfo ( [ECO#] )
SELECT tblMain.[ECO#]
FROM tblMain LEFT JOIN tblECRInfo ON tblMain.[ECR#] = tblECRInfo.[ECR#]
WHERE (((tblMain.[ECO#])=[frmECR
].[ECO#]))
;
UPDATE (tblMain LEFT JOIN tblECOInfo ON tblMain.[ECO#] = tblECOInfo.[ECO#]) LEFT JOIN tblECRInfo ON tblMain.[ECR#] = tblECRInfo.[ECR#] SET tblECOInfo.[DrawingsToCrea
te/Edit] = tblECRInfo![DrawingsToCrea
te/Edit], tblECOInfo.[ItemsToCreate/
Edit] = tblECRInfo.[ItemsToCreate/
Edit], tblECOInfo.[BOMsToCreate/E
dit] = tblECRInfo![BOMsToCreate/E
dit]
WHERE (((tblECOInfo.[ECO#])=));
Please HELP!! ::pulling hair out::
Start Free Trial