Copy And Paste data From a Form ????

[Guest]

I have two forms with each of them possess a subform(Datasheet) .
First Form : Marketing (Invoice)
Second : Industry (Invoice)

First form has one checkbox
Both of the form is exactly identical even the field in it but based on
their own respective table

Question:

How to append recordsets in the subform in first subform to subform of
second form programmtically when i check the checkbox and delete recordsets
if i uncheck the checkbox? (Append query cant help coz key violation in
lookup field)

I want each page in first form for each page in second form.

Any solutions?

Thanks in advance

Kennykee

 

[Guest]

As I'm reading this you want to Append the Invoice list from Marketing_Table
to the Invoice list in Industry_Table but run into key violations.

I would guess you're getting these because the common field is the Invoice
number and that field is defined as PK/Unique in Idustry_Table???

If that's so:
Have you tried creating the append query with the where clause:

"Where Invoice_Table!Invoice_Number is null"

This will preclude the query from trying to append the already existing
Invoice into the Invoice_Table.

BAC

 

[Guest]

Thanks BAC
I will try it out
Sorry for the late reply because Internet Service Provider's server down