Repopulate Form of a Multi Option Button

[TellM1955]

I have a form with a number of multi option groups that, using the code below write the data to the record. However, what I want to do is to recall that option selected back to the form for editing and I can't find how this is done. Can anyine assist?

      If Me.OptionTuePME.Value Then .Cells(NewRow, 14).Value = "E"
      If Me.OptionTuePML.Value Then .Cells(NewRow, 14).Value = "x"
      If Me.OptionTuePMNR.Value Then .Cells(NewRow, 14).Value = ""

 

[dmt32]

Hi
testing for each of those values should return True / False to each of the controls

      Me.OptionTuePME.Value = .Cells(NewRow, 14).Value = "E"
      Me.OptionTuePML.Value = .Cells(NewRow, 14).Value = "x"
      Me.OptionTuePMNR.Value = .Cells(NewRow, 14).Value = ""

Do note that tests are case sensitive & may want to consider making it case insensitive if there is possibility that your application may post data to the range in a different format.

Dave

 

[TellM1955]

Dave, that's what I wanted. Cheers

 

[dmt32]

Dave, that's what I wanted. Cheers

most welcome & appreciate your feedback

Dave