Importing forms

GagaZ

New member
Local time
Yesterday, 18:02
Joined
Dec 5, 2007
Messages
9
Hi,
I have following problem :
I want to import data from one form to other in same access program.
I have form 1 Quotation (in relation to Customer and Product items tables) and form 2 Invoices (in relation to the same tables)
I have created Quotation (nr 125,126,127) all with different data (customers and products).
Quotation form and Invoice have product items subform.
I want to import only quotation nr 126 to Invoice form.
I tried different ways (append query) but every time I'm just copying (appending) whole product item list to invoice form. I want only quotation 126 to go in Invoice form as only that one is approved for supply.

Exmpl:
Quotation Form have:
-Customer: Id, Name, Address
-Quotation: Date and Quotation Nr
--- Subform
-Products: Name, Id, Quantity, UnitPrice.....
I want to copy Quotation Form Nr (exmpl 126) with whole data of customers and products to Invoice Form .
Invoice Form
-Customer: Id, Name, Address
-Invoice: Date and Invoice Nr
--- Subform
-Products: Name, Id, Quantity, UnitPrice.....
Tks for help
GagaZ
 

Users who are viewing this thread

Back
Top Bottom