Advertisement

07.21.2008 at 01:32PM PDT, ID: 23583317
[x]
Attachment Details

Issue with Parameter Value on Append and Update Query commands

Asked by r_johnston in Microsoft Access Database

Tags: , ,

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.[DrawingsToCreate/Edit] = tblECRInfo![DrawingsToCreate/Edit], tblECOInfo.[ItemsToCreate/Edit] = tblECRInfo.[ItemsToCreate/Edit], tblECOInfo.[BOMsToCreate/Edit] = tblECRInfo![BOMsToCreate/Edit]
WHERE (((tblECOInfo.[ECO#])=));

Please HELP!!  ::pulling hair out::Start Free Trial
 
Keywords: Issue with Parameter Value on Append…
 
Loading Advertisement...
 
[+][-]07.21.2008 at 01:44PM PDT, ID: 22054186

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: Microsoft, Access, 2003
Sign Up Now!
Solution Provided By: omgang
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.21.2008 at 01:57PM PDT, ID: 22054282

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.22.2008 at 05:30AM PDT, ID: 22058572

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628