Open/Close subforms within a form
Posted: Fri Jan 26, 2024 7:07 pm
Hello,
I am preparing a DB to help me prepare quotations faster.
I have many categories of products (so far 9 categories). Categories are stored in their own table as they all have their particularities.
On my quote form, each category is filtered using cascading listboxes. At the end, I get a specific SKU, price, and so on. The SKU is added on the quote.
The problem I am facing is the following, my quote form is overcrowded.
To help reduce the amount of information on my quote form, I tried a listbox calling another form for each category but I am losing the link between my quote number and my line number of that particular quote.
Any suggestions?
Thanks for your help.
I am preparing a DB to help me prepare quotations faster.
I have many categories of products (so far 9 categories). Categories are stored in their own table as they all have their particularities.
On my quote form, each category is filtered using cascading listboxes. At the end, I get a specific SKU, price, and so on. The SKU is added on the quote.
The problem I am facing is the following, my quote form is overcrowded.
To help reduce the amount of information on my quote form, I tried a listbox calling another form for each category but I am losing the link between my quote number and my line number of that particular quote.
Any suggestions?
Thanks for your help.