Tab through subform
- Thread starter ClaraBarton
- Start date
ClaraBarton
Registered User.
- Local time
- Today, 04:33
- Joined
- Oct 14, 2019
- Messages
- 606
Sorry... I put it on a back burner and moved on.
So how can I look at multiple invoices under each customer?
So how can I look at multiple invoices under each customer?
ClaraBarton
Registered User.
- Local time
- Today, 04:33
- Joined
- Oct 14, 2019
- Messages
- 606
Now I remember... I had to do that to keep it a continuous form. I didn't realize it would mess up my tabbing. Back to the drawing board... Thank you for your time.
LarryE
Active member
- Local time
- Today, 04:33
- Joined
- Aug 18, 2021
- Messages
- 842
@ClaraBarton
Your project design is not correct, so it's no wonder it doesn't work for you. I'll see if I can make it work properly for you.
Your project design is not correct, so it's no wonder it doesn't work for you. I'll see if I can make it work properly for you.
LarryE
Active member
- Local time
- Today, 04:33
- Joined
- Aug 18, 2021
- Messages
- 842
I can create a form for you to see all invoices for each customer if you wish
Last edited:
LarryE
Active member
- Local time
- Today, 04:33
- Joined
- Aug 18, 2021
- Messages
- 842
Yeah, that's what I am doing for the OP. I needed to get it normalized and in a proper design first.
LarryE
Active member
- Local time
- Today, 04:33
- Joined
- Aug 18, 2021
- Messages
- 842
This might be what you need to see all invoices for each customer.
In this example, customer Test Again 1 has two invoices which can be viewed in the sib-form below the invoice input sub-form. Each customers invoices are shown as you select each one.
What does this business do? Do you sell sewing patterns or sell sewing services or both? It appears you charge customers for certain sewing services as in the examples below:
In this example, customer Test Again 1 has two invoices which can be viewed in the sib-form below the invoice input sub-form. Each customers invoices are shown as you select each one.
What does this business do? Do you sell sewing patterns or sell sewing services or both? It appears you charge customers for certain sewing services as in the examples below:
ClaraBarton
Registered User.
- Local time
- Today, 04:33
- Joined
- Oct 14, 2019
- Messages
- 606
Wow! You went above and beyond. I design patterns for individuals. Thank you for your work. Completely unexpected! Is the bottom list of invoices a report? Is it in the footer?
Last edited:
LarryE
Active member
- Local time
- Today, 04:33
- Joined
- Aug 18, 2021
- Messages
- 842
I am attaching the file I worked on. The data has changed. I deleted some test stuff you had and added some for testing purposes. The table structure and relationships have also changed so that it works as a relational model. I didn't delete any of the forms that are not used but did change some of the VBA code so it works better and more efficiently. I don't know where you got some of it, but that's OK.
I also didn't touch any reports. I have not looked at them. The way I understand it, you want to track customers invoices and the detail of items charged on those invoices. You are also tracking the invoice receipts.
The list of customer invoices is simply another sub-form of the invoices form. It's linked to each customer just like the invoices form is.
If you have further questions or problems, let us know.
