Copy And Paste data From a Form ????

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thanks BAC
I will try it out
Sorry for the late reply because Internet Service Provider's server down
 
Back
Top