Im a new user to Access. I am trying to group several Date-related option buttons with combo Drop Down lists to select one option at a time.
I've looked through many pages of docs and access books (including Access Cookbook), which has a nice example in ch2.4, but not quite what I'm looking for.
Here is my form that generates reports:
<table>
<tr><td>option buttons: </td> <td> combo boxes:</td></tr>
<tr><td>Month </td> <td> drop-down for months </td></tr>
<tr><td>FiscalQtr </td> <td> drop-down for fqtrs </td></tr>
<tr><td>FiscaYear </td> <td> drop-down for fyears </td></tr>
<tr><td>CalQtr </td> <td> drop-down for cqtrs </td></tr>
<tr><td>CalYear </td> <td> drop-down for cyears</td></tr>
</table>
I'd like to make each option button mutually exclusive and allow combo box select for only the field for which the option button is pressed.
I have a access table which has 5 option fields organized in 5 columns (cookbook example describes single column option choices), and I use RowSource Parameter query to select drop-down fields in the combo boxes.
I've looked through many pages of docs and access books (including Access Cookbook), which has a nice example in ch2.4, but not quite what I'm looking for.
Here is my form that generates reports:
<table>
<tr><td>option buttons: </td> <td> combo boxes:</td></tr>
<tr><td>Month </td> <td> drop-down for months </td></tr>
<tr><td>FiscalQtr </td> <td> drop-down for fqtrs </td></tr>
<tr><td>FiscaYear </td> <td> drop-down for fyears </td></tr>
<tr><td>CalQtr </td> <td> drop-down for cqtrs </td></tr>
<tr><td>CalYear </td> <td> drop-down for cyears</td></tr>
</table>
I'd like to make each option button mutually exclusive and allow combo box select for only the field for which the option button is pressed.
I have a access table which has 5 option fields organized in 5 columns (cookbook example describes single column option choices), and I use RowSource Parameter query to select drop-down fields in the combo boxes.