Re-post ... still looking for a way ...

  • Thread starter Thread starter Joe Best
  • Start date Start date
J

Joe Best

on a form I have an option group control with six options (type 1 to 6). I
also have a search field and a sub form which returns details of the record
which I have searched for or displays the filtered records driven by which
option I select in the option group.

when someone searches for a record and that record is displayed in the sub
form, I would like for the correct radio button to be highlighted with the
record type which is currently displayed.

currently, when a record is found, the radio button selected is always
option 1.

can anyone please offer any advice as to how to implement this with code.
hope I've explained this so it's understandable.

Many thanks,

Joe.
 
The option group is within a frame

Simply set the frame to equal the value you want and the option will chang

if the frame was called frm
the

frm1=

This would highlight option button 2
 
on a form I have an option group control with six options (type 1 to 6). I
also have a search field and a sub form which returns details of the record
which I have searched for or displays the filtered records driven by which
option I select in the option group.

when someone searches for a record and that record is displayed in the sub
form, I would like for the correct radio button to be highlighted with the
record type which is currently displayed.
Click to expand...

Use the Form's Current event to set the value of the Option Group:

Private Sub Form_Current()
Parent!optRecordType = Me!RecordType
End Sub
 
Back
Top