Hi. I am currently having problems with my option group.
My form has a grid, a start date textbox, an end date textbox, a run button, and an option group.
The grid that displays a table with date, invoice, and item as fields.
The textboxes are where a user enters the date range of records to be displayed.
The button is to display the records within the date entered.
The option group has 3 choices: date, invoice, and item. The purpose is to sort the table by among the 3 choices, with a change in background color. For example, if a user clicks the option date, then the table will be sorted by date, and the background color of the date field will change to gray. If the user clicks the option invoice, then the sort will change by invoice, and the background color of the date field will turn back to white while the invoice field will turn to gray. Note: table is initially sorted by date after clicking run button.
At first run, the table is sorted by date with date field color at gray. If I click on the option invoice to change the sort and color, then run again, the table is sorted by date, but the colors of both date and invoice are gray, and the option invoice is still selected. Is there a way to reset the option group, or perhaps I should switch to buttons?
My form has a grid, a start date textbox, an end date textbox, a run button, and an option group.
The grid that displays a table with date, invoice, and item as fields.
The textboxes are where a user enters the date range of records to be displayed.
The button is to display the records within the date entered.
The option group has 3 choices: date, invoice, and item. The purpose is to sort the table by among the 3 choices, with a change in background color. For example, if a user clicks the option date, then the table will be sorted by date, and the background color of the date field will change to gray. If the user clicks the option invoice, then the sort will change by invoice, and the background color of the date field will turn back to white while the invoice field will turn to gray. Note: table is initially sorted by date after clicking run button.
At first run, the table is sorted by date with date field color at gray. If I click on the option invoice to change the sort and color, then run again, the table is sorted by date, but the colors of both date and invoice are gray, and the option invoice is still selected. Is there a way to reset the option group, or perhaps I should switch to buttons?