It sounds like you do not intend to let the user edit on the subform. Have you tried just disabling the subform?
could try this on the subform
If Me.SelHeight > 0 Then
Me.SelHeight = 0
End If
You get that because the first record is selected - combo box seems to have the focus too.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
The user will be updating information in that form. Changing "Enabled" on the subform didn't remove the highlighting.
How will you indicate which row of the sub form the cursor is on?
Each fields has conditional formatting that turns a color when it has the focus.
Got it. I'll play a bit and get back to you.
Then methinks your only option is to convert the form to a continuous view. If you need the datasheet look, you can replicate that in a continuous form. If you don't want the control with the focus in the first record to look selected or highlighted, then in the GotFocus events for such controls, you can set their SelLength to zero.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Using a continuous form won't work. The client needs to be able to sort and filter the data in the form. Some records have a large number of rows in that subform.
I don't see the problem with being able to do sorting and filtering on a continuous form. Since you seem to be so sure of what won't work without considering much of anything suggested to you, I will bow out.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
All I meant was that the client likes the format of the datasheet. It sorts and filters like Excel which they are familiar with and they can also move the columns around.
Maybe there is something in here: https://vb123.com/you-can-do-that-with-datasheets/ that you can use.