Tab through subform (1 Viewer)

If you need to requery a form and stay on the same record, requery the form recordset, NOT the form.
 
Sorry... I put it on a back burner and moved on.
So how can I look at multiple invoices under each customer?
 
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.
 
@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.
 
Sorry... I put it on a back burner and moved on.
So how can I look at multiple invoices under each customer?
I can create a form for you to see all invoices for each customer if you wish
 
Last edited:
You could have a mainform with customer details and a subform for their invoices, linked by customerID.
 
You could have a mainform with customer details and a subform for their invoices, linked by customerID.
Yeah, that's what I am doing for the OP. I needed to get it normalized and in a proper design first.
 
This might be what you need to see all invoices for each customer.
1728484944764.png

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:
1728485502673.png
 
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:
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?
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.
 

Attachments

Users who are viewing this thread

Back
Top Bottom