Option group help. Have to click away or hit tab to chose another

[mxfrail]

Here is the code for the option group. For some odd reason if I select an option I have to click away, or press tab, before I can select another. If I don't press tab then my clicks do nothing.

Has anyone encountered this before? Is there a way to force something into the vba code of the afterupdate so that a tab does not need to be pressed?

Private Sub opCreditApplied_AfterUpdate()

If Me.opCreditApplied = 1 Then
Me.sfInvoicesAvail.Visible = False
Me.sfInvoicesAvail_Label.Visible = False

Else
Me.sfInvoicesAvail.Visible = True
Me.sfInvoicesAvail_Label.Visible = True


End If

 

[mxfrail]

Ignore this ...

Figured out issue with a control not being invisible after posting this.

 

[TheAceMan1]

How are ya mxfrail . . .

Glad you got it! Here's an Idea of [blue]shorter code[/blue] (couldn't resist!):

[blue]   Me.sfInvoicesAvail.Visible = (Me.opCreditApplied <> 1)
   Me.sfInvoicesAvail_Label.Visible = (Me.opCreditApplied <> 1)[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[jamaarneen]

Hi mxfrail,

I replied to your (newer) thread "Option Group - text box conflicts?".

Isn't it the same problem?
maybe my advise might help for this too.

Ja

 

[mxfrail]

Its the same problem.

I have identified where the problem is. In talking with another member in my group about 'to back' and 'to front' has caused problems in the past.

I want to avoid having to recreate the form completely from scratch. It just seems odd that visble = false and such is not working.

 

[TheAceMan1]

mxfrail . . .

Its possible its a bug. What version are you using?

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[mxfrail]

2003 sp3