Are option buttons an option?

[Pittsy]

I have a pair of option buttons in a form "repaired" and "Scrapped", I would like the focus to switch to a different control depending on which is chosen. as there is no OnClick to put an event into, how do I do this?

Advice will be much appreciated
Pittsy

[ranman256]

its not onClick, you want AFTERUPDATE .
add a FRAME, put the options in it. the FRAME gets the value and the events.
event of the FRAME afterupdate , when the user picks it , turn on or off other items.

sub frame_afterupdate()
  select case frame.value
      case 0
         txtBox = "Repaired"
      case 1
          txtBox = "scrapped"
end select

[Pittsy]

Great but how do I tell it where to go (so to speak)? If they select repaired I want to go to Repairs done control, If they choose scrapped I want to go to Date Scrapped. Sorry if this is making me look a bit foolish..

[ssanfu]

Using the example form Ranman256, the code might look like:

(Option value for "Repaired" = 1, Option value for "scrapped" = 2)

sub frame1_afterupdate()
  SELECT Case frame1.value
      Case 1
        'If the control name is "Repairs_done"
        Me.Repairs_done.SetFocus
      Case 2
        'If the control name is "Date_Scrapped"
        Me.Date_Scrapped.SetFocus
End Select

Note that I replaced the space with underscores in the control names.....

Replace "Frame1" with the name of your frame control and the "Repaired" & "Scrapped" controls with your names.

[Pittsy]

Brilliant guys,

Works a dream.

Thanks for your input.

Pittsy

[ssanfu]

It sounds like your problem is solved. I will mark this "Solved" for you.