Hi all, hope you can help.
I have a continuous form show multiple records, fine, I have a text box behind all fields on the form and another hidden unbound text box in the form header, I have this in my oncurrent event of the form,
Private Sub Form_Current()
If Nz(Me.Unitid) <> "" Then
Me.txtcurrentrecord = Me.Unitid
End If
End Sub
The text box on the cpontinmuous part is coloured via conditional format to change colour when record is selected so I know where I am.
I also have a search combo box that finds a record and takes me to that record. That works fine, but that does always show that the found record is the current record and so does not highlight it as though I had selected it.
So I found some code to change the colour of another textbox behind the record via conditional formatting, very simply
[combo72].[Value]=[unit].[Value] in the expression part of the conditional foratting.
What I would like to do is combine the 2.
I have a continuous form show multiple records, fine, I have a text box behind all fields on the form and another hidden unbound text box in the form header, I have this in my oncurrent event of the form,
Private Sub Form_Current()
If Nz(Me.Unitid) <> "" Then
Me.txtcurrentrecord = Me.Unitid
End If
End Sub
The text box on the cpontinmuous part is coloured via conditional format to change colour when record is selected so I know where I am.
I also have a search combo box that finds a record and takes me to that record. That works fine, but that does always show that the found record is the current record and so does not highlight it as though I had selected it.
So I found some code to change the colour of another textbox behind the record via conditional formatting, very simply
[combo72].[Value]=[unit].[Value] in the expression part of the conditional foratting.
What I would like to do is combine the 2.
