Option Groups

[Guest]

Does anyone know how to have the results of one option group affect the
results of another option group? I have two fields in the first option group
(debits and credits), if a user selects credits then the button on the second
option group would be selected causing other things to happen associated with
that button (kind of a default for only credits). Thanks!

 

[Guest]

Hi James,

Have an On Click event behind your option group, and when the user clicks on
Credit (or Debit, or whatever) use that to trigger a call to your other
function, like this:

select case me.optgrpDebitCredit
case Credit
call function here

case Debit
call function here

case else
msgbox "not sure how you got here"

end select

This assumes that Debit and Credit are defined as constants... they most
likely have numeric values behind your option group - remember to take this
into account.

Hope this helps.

Damian.

 

[Guest]

Damian, what do you mean by "call funtion here"?

Hi James,

Have an On Click event behind your option group, and when the user clicks on
Credit (or Debit, or whatever) use that to trigger a call to your other
function, like this:

select case me.optgrpDebitCredit
case Credit
call function here

case Debit
call function here

case else
msgbox "not sure how you got here"

end select

This assumes that Debit and Credit are defined as constants... they most
likely have numeric values behind your option group - remember to take this
into account.

Hope this helps.

Damian.