R
Robert Nusz @ DPS
I have a form with multiple OptionButtons to be utilized by the user.
Problem is, I want to control these so that the user has to click the first
option button to build file, 2nd button on completion to run query, 3rd
button to create report etc. The optionbuttons currently work fine, but if
the user clicks option button 2 first, the query fails, I've got the option
buttons set to default of value of false on screen open. I want to have the
2nd & 3rd button grey out or not selectable on screen open, on successfull
optionbutton 1 run, deselect/grey out button 1, allow only button 2
selectable leaving 3 greyed out/delselected, on successful run of option 2,
deselect 2, leave 3 selectable, and at the end, all buttons not selectable,
only option is exit. Only reset option buttons on open. Any suggestions on
code would be great as I'm not very VB literate. The option buttons on this
form are labeled: Option10, Option20, Option30, with command button marked
EXIT, which closes form, returns to main menu. Thanks in advance.
Problem is, I want to control these so that the user has to click the first
option button to build file, 2nd button on completion to run query, 3rd
button to create report etc. The optionbuttons currently work fine, but if
the user clicks option button 2 first, the query fails, I've got the option
buttons set to default of value of false on screen open. I want to have the
2nd & 3rd button grey out or not selectable on screen open, on successfull
optionbutton 1 run, deselect/grey out button 1, allow only button 2
selectable leaving 3 greyed out/delselected, on successful run of option 2,
deselect 2, leave 3 selectable, and at the end, all buttons not selectable,
only option is exit. Only reset option buttons on open. Any suggestions on
code would be great as I'm not very VB literate. The option buttons on this
form are labeled: Option10, Option20, Option30, with command button marked
EXIT, which closes form, returns to main menu. Thanks in advance.