I have a check Box, a comboBox and 2 option buttons (OptbtnA & OptbtnB) in an option group on the mainform and have created 2 select queries (qry_btnA and qry_btnB) based on 2 different tables (ProdMain & ProdAux).
I want that when the checkbox is checked and the user selects an option button the appropriate query is run and the comboBox is loaded with data from the corresponding table.
For example,If the checkbox is checked and option button "OptbtnA" is selected query "qry_btnA" (Select distinct ProdName from ProdMain)
would be executed.
and when the checkbox is checked and option button "OptbtnB" is selected query "qry_btnB" (Select distinct ProdName from ProdAux) would be executed.
Don't know whether it is possible to use an IIF() on the row source of the combo box ? like IF(Frame1=1,"qry_btnA","qry_btnB"
I am lost on what I have to do and desperately need help.
I want that when the checkbox is checked and the user selects an option button the appropriate query is run and the comboBox is loaded with data from the corresponding table.
For example,If the checkbox is checked and option button "OptbtnA" is selected query "qry_btnA" (Select distinct ProdName from ProdMain)
would be executed.
and when the checkbox is checked and option button "OptbtnB" is selected query "qry_btnB" (Select distinct ProdName from ProdAux) would be executed.
Don't know whether it is possible to use an IIF() on the row source of the combo box ? like IF(Frame1=1,"qry_btnA","qry_btnB"
I am lost on what I have to do and desperately need help.