incagold
Programmer
- Mar 21, 2003
- 54
Is it possible to select a value from an option group and have that value determine which query to use for a subform? If so, can you provide an example of the code?
The objective is to select 1 of 3 values in a selction group which determine different finacial data to display. I cannot be very specific because of the nature of our business but for example option 1 would be budgetary data for an aircraft simulator, option 2 would be the same type of budgetary for spare parts for the simulator while option 3 would display all financial data associated with the simulator. Once selected the subform provides the link via selection to several additional subforms appropriate to the 3 options above
I am relatively new to Access and am trying to learn. You have provided me value assistance previously via threads and your base of FAQs and Posts. I'm hoping I have explained my problem sufficiently for you and offer my sincere thanks in advance for any help.
The objective is to select 1 of 3 values in a selction group which determine different finacial data to display. I cannot be very specific because of the nature of our business but for example option 1 would be budgetary data for an aircraft simulator, option 2 would be the same type of budgetary for spare parts for the simulator while option 3 would display all financial data associated with the simulator. Once selected the subform provides the link via selection to several additional subforms appropriate to the 3 options above
I am relatively new to Access and am trying to learn. You have provided me value assistance previously via threads and your base of FAQs and Posts. I'm hoping I have explained my problem sufficiently for you and offer my sincere thanks in advance for any help.
