How do I do This?

[murlen]

I would like to place a check box on my form and when 'checked' will proform
an append query to a table for the current record I am on.


any Ideas?

Murlen

 

[llkhoutx]

On the AfterUpdate event of the checkbox, if the result is True execute your append query, otherwise, do nopthing.

 

[murlen]

I need to add records for TestID, TestNumber, TestDescription from CellTestInt table to Junction2 table and add records for TestID, TestNumber, TestDescription from SystemCheckInt table and records for System form Systems table to SystemTest table for the current record ChartInfo.ChartID. (note: records in both CellTestInt and SystemCheckInt are different)

Instead of opening an append query how do I write this in the code for the afterupdate procedure.

Murlen

 

[llkhoutx]

What's wrong with an append query?

 

[murlen]

I couldn't get the append quary to work with the current record
what needs to be in the quary to select the current recordset?
plus it would have to call two quarys

Thanks
Murlen

P.S.
here is one of my quarys
INSERT INTO Junction2 ( ChartID, TestID, TestNumber, TestDescription )
SELECT ChartInfo.ChartID, CellTest.TestID, CellTest.TestNumber, CellTest.TestDescription
FROM ChartInfo (not sure what this should be, CellTest
WHERE ChartInfo.ChartID not in (Select ChartID from Junction2);

 

[murlen]

okey I got it...

I used WHERE ChartInfo.ChartID = Forms!ChartInfo!ChartID

Next Question...
What if I didn't want the warning "you are about to run an append..." displayed
how do I just make it appendand ignore warnings?


Murlen

 

[llkhoutx]

Docmd.setwarnings false

'your stuff

docmd.setwarnings true

 

[murlen]

Cool!
Thanks

I missed one thing from the append

I don't want to duplacate records allready enter so I was using "WHERE NOT IN"

How do I add this to the statment

INSERT INTO Junction2 ( ChartID, TestID, TestNumber, TestDescription )
SELECT ChartInfo.ChartID, CellTestInt.TestID, CellTestInt.TestNumber, CellTestInt.TestDescription
FROM ChartInfo, CellTestInt
WHERE ChartInfo.ChartID = Forms!ChartInfo!ChartID;

 

[llkhoutx]

INSERT INTO Junction2 ( ChartID, TestID, TestNumber, TestDescription )
SELECT ChartInfo.ChartID, CellTestInt.TestID, CellTestInt.TestNumber, CellTestInt.TestDescription
FROM ChartInfo, CellTestInt
WHERE ChartInfo.ChartID = Forms!ChartInfo!ChartID AND NOT (whatever);

 

[llkhoutx]

INSERT INTO Junction2 ( ChartID, TestID, TestNumber, TestDescription )
SELECT ChartInfo.ChartID, CellTestInt.TestID, CellTestInt.TestNumber, CellTestInt.TestDescription
FROM ChartInfo, CellTestInt
WHERE ChartInfo.ChartID = Forms!ChartInfo!ChartID AND NOT (whatever);

or Group the input records, eliminating duplicates.