Hello everybody.
I have a database where I store customer orders and supplier orders at the same time. These orders are very similar so the form can look the same. I have these forms:
- orders overview
- order card
- order details subform
- data entry forms
There are buttons for adding a new order, editing an order, navigation etc.
In the main menu, there are buttons: CUSTOMER ORDERS and SUPPLIER ORDERS. I want to set record sources for all those forms based on the button an user clicked on in the main menu. How do I approach this?
I also need specific objects to have their default value set based on the button.
One solution would be to create duplicate forms but I have a feeling that there is a more elegant way.
Thanks,
Tomas