Hi. I am new to VB(A) but willing to learn fast (and to make time for it,...) so here is my "very little" problem. I have made a Form in Access2000 and created 2 listboxes on it (both multiselect). The result of those selections should act like an SQL-statement or query
to be used on a Report. I made a Botton on the Form to trigger the Report. This is where VBA or VB comes in and that's why I am new on this forum,... .
The listboxes are filled with the domains of the tables Areas (Stock A - Stock B - Stock Central - All Stocks) and Types (Workstation - Keyboard - Screen - Printer - ....).
The goal is to select for example Screens and Keyboards from Stock A and Stock B and put them in a Report I already created before (so I have a clean output from the inventory). The problem at the moment is that I can't find the right way to "read" the selection in the boxes
and use them as the Query or SQL-statement for the Report.
Please don't solve the problem completly, all hints in the good direction that would help me solve the problem are more than welcome (and I learn the most out of it).
Thanks.
to be used on a Report. I made a Botton on the Form to trigger the Report. This is where VBA or VB comes in and that's why I am new on this forum,... .
The listboxes are filled with the domains of the tables Areas (Stock A - Stock B - Stock Central - All Stocks) and Types (Workstation - Keyboard - Screen - Printer - ....).
The goal is to select for example Screens and Keyboards from Stock A and Stock B and put them in a Report I already created before (so I have a clean output from the inventory). The problem at the moment is that I can't find the right way to "read" the selection in the boxes
and use them as the Query or SQL-statement for the Report.
Please don't solve the problem completly, all hints in the good direction that would help me solve the problem are more than welcome (and I learn the most out of it).
Thanks.