Hi there,
I am stuck with using a DLookUp whilst making an invoice style report.
I am using 2 Tables
"Transactions" & "Products" with Fields :
TransID ProductID
Product1 ProductName
Product2 ProductPrice
Product3 ShippingPrice
Product4
Product5
Products1-5 Are Filled In A Form By A DropDown Box Linked To ProductID
The Report(Invoice) Is Based On The "Transactions" Table
What I need is for the Report(Invoice) to have a column of textboxes next to all 5 Product Boxes with a DLookUp filling them with the correct ProductPrice.
Then another column of textboxes with a DLookUp for the correct Shipping Price per item.
I am completley lost :/
Any help would be great
I am stuck with using a DLookUp whilst making an invoice style report.
I am using 2 Tables
"Transactions" & "Products" with Fields :
TransID ProductID
Product1 ProductName
Product2 ProductPrice
Product3 ShippingPrice
Product4
Product5
Products1-5 Are Filled In A Form By A DropDown Box Linked To ProductID
The Report(Invoice) Is Based On The "Transactions" Table
What I need is for the Report(Invoice) to have a column of textboxes next to all 5 Product Boxes with a DLookUp filling them with the correct ProductPrice.
Then another column of textboxes with a DLookUp for the correct Shipping Price per item.
I am completley lost :/
Any help would be great