Microsoft Access 2016 - Invoice Help!!

joe904

Estimable
Apr 11, 2015
11
0
4,560
0
Hi Guys,
I am creating an invoice using MS Access for a friend, but I am having some difficulty finishing it. I created a table called "Customers" and "Invoice Details." Invoice Details has all of the invoice info such as Invoice Number, TotalHours worked, and UnitPrice. The problem that I am having is that I created a form called "Customer Input". It has tabs one for "General" where the customer data is input, and another for "Invoice layout" where they can enter each separate line of the invoice. When I set up the tabs for the form, I had to select a "Record Source" which I set up for the customer data. Since the other tab pulls info from the "Invoice Details" table, how do I connect this record source. I have tried this expression, but it does not work:
[Invoice Details]![TotalHours].
Hopefully I have explained this correctly and have made some sense. If there is a better way of setting this up, I am welcome to any and all suggestions. I have included a picture to help explain.


 
Thread starter Similar threads Forum Replies Date
MBA380 Apps General Discussion 3
omar muzzammil Apps General Discussion 2
M Apps General Discussion 1
R Apps General Discussion 1
S Apps General Discussion 5
Paul Wagenseil Apps General Discussion 2
henrytcasey Apps General Discussion 8
G Apps General Discussion 2
G Apps General Discussion 8
O Apps General Discussion 1
joe904 Apps General Discussion 1
ssddx Apps General Discussion 5
viveknayyar007 Apps General Discussion 0
viveknayyar007 Apps General Discussion 0
viveknayyar007 Apps General Discussion 0
viveknayyar007 Apps General Discussion 0
shattered space Apps General Discussion 2
J Apps General Discussion 5
H Apps General Discussion 1
S Apps General Discussion 1

ASK THE COMMUNITY