When you select a value from combo, highlight this entry in the datasheet of the Access subform

Question

I have an access form with a drop-down list and a subformat. The subform is in data table mode (the way I want it). What I'm trying to do is a kind of search function. When something is selected from the drop-down list, I want the data in the form of a subform to scroll and select the corresponding record.

I do not want to filter the subform (i.e. delete all inappropriate entries).

Can someone give me some tips on how to achieve this?

Answer 1

Something like that:

Private Sub Combo0_AfterUpdate(): With Me.Child0.Form.Recordset .FindFirst "ID_Field=" & Me.Combo0 End With End Sub