Hi,
Im building a database in Access with the use of VB.
If I have 2 tables, both of which will be used as a subreport/form:
1 - Invoice Details
a - Invoice Number : Integer
b - Item: String
c - Quantity - Number
d - Rate/Cost/Wateva - Currency
e - Amount - Currency (Ammount defind by Qty * Rate, on either field being changed)
2 - Quote Details
a - Invoice Number : Integer
b - Item: String
c - Quantity - Number
d - Rate/Cost/Wateva - Currency
e - Amount - Currency (Ammount defind by Qty * Rate, on either field being changed)
AND
f - Comments
If i wanted to take the records from Quote Details and transfer them into the Invoice Details table, how could I do it?
Ive beeing trying the clone method, without success and have also tried to open both forms/tables and using automation from access, add a new record to invoice, but it wont seem to work. Cant find an Add Record feature in VB,
May seem a simple problem, but Im pretty new at VB.
Ive been able to work arround this problem by creating a query on the quotes table and inserting it as the subform, but i physically need to add the records to the invoice details table. At the moment there can be loop holes in the program, esspecially since im making 3 different types of invoices, the one above and 2 others that use the invoice details table,
Any ideas?
Thanks
J