brunces
Registered User.
- Local time
- Today, 15:40
- Joined
- Sep 12, 2004
- Messages
- 45
Friends,
Please, tell me if it's possible and how to do it.
- I have 1 table (tblProducts).
- I have 3 queries based on that table (qryProd1, qryProd2, qryProd3).
- Those 3 queries have the same structure, they are identical, but each one has different criteria for filtering records from tblProducts.
- I have 3 forms based on those queries (frmProd1, frmProd2, frmProd3).
- Those 3 forms also have the same structure, they are also identical, but each one is based on its respective query.
- I have a MENU (form) with 3 buttons (btnProd1, btnProd2, btnProd3). Each button opens its respective form.
Now, here is my point: Is it possible to use ONLY ONE FORM with 3 different queries? Not at the same time, of course. For example...
There would be only one form (frmProd).
When I click on btnProd1, the form frmProd should be opened, based on qryProd1.
When I click on btnProd2, the same form frmProd should be opened, now based on qryProd2.
And when I click on btnProd3, the same form frmProd should be opened, now based on qryProd3.
Is this possible? If so, how can I do it?
Thanks for your attention, guys.
Hugs,
Bruce
Please, tell me if it's possible and how to do it.
- I have 1 table (tblProducts).
- I have 3 queries based on that table (qryProd1, qryProd2, qryProd3).
- Those 3 queries have the same structure, they are identical, but each one has different criteria for filtering records from tblProducts.
- I have 3 forms based on those queries (frmProd1, frmProd2, frmProd3).
- Those 3 forms also have the same structure, they are also identical, but each one is based on its respective query.
- I have a MENU (form) with 3 buttons (btnProd1, btnProd2, btnProd3). Each button opens its respective form.
Now, here is my point: Is it possible to use ONLY ONE FORM with 3 different queries? Not at the same time, of course. For example...
There would be only one form (frmProd).
When I click on btnProd1, the form frmProd should be opened, based on qryProd1.
When I click on btnProd2, the same form frmProd should be opened, now based on qryProd2.
And when I click on btnProd3, the same form frmProd should be opened, now based on qryProd3.
Is this possible? If so, how can I do it?
Thanks for your attention, guys.
Hugs,
Bruce