<div>
To go to your selected record, add something like this in your combo box's AfterUpdate event:<br />

<pre><code id="code-20-40639606-1">    With Me.frmMain_sf.Form.RecordsetClone
        .FindFirst &quot;[UniqueKeyField] = '&quot; &amp; Me.cmbNameOfComboBox &amp; &quot;'&quot;
        If Not .NoMatch Then
            Me.frmMain_sf.Form.Bookmark = .Bookmark
        End If
    End With</code></pre>
<br />
If the UniqueKeyField in is a Numeric data type, change the FindFirst line to this instead:<br />
<b>.FindFirst &quot;[UniqueKeyField] = &quot;&nbsp;&amp; Me.cmbNameOfComboBox</b><br />
<br />
Ron
</div>


To go to your selected record, add something like this in your combo box's AfterUpdate event:


    With Me.frmMain_sf.Form.RecordsetClone
        .FindFirst "[UniqueKeyField] = '" & Me.cmbNameOfComboBox & "'"
        If Not .NoMatch Then
            Me.frmMain_sf.Form.Bookmark = .Bookmark
        End If
    End With


If the UniqueKeyField in is a Numeric data type, change the FindFirst line to this instead:
.FindFirst "[UniqueKeyField] = " & Me.cmbNameOfComboBox

Ron

<div>
Search works great. Is there a way to change the row color of the selected row?
</div>


Search works great. Is there a way to change the row color of the selected row?

<div>
Did you miss my second posting?
</div>


<div>
I did, sorry. &nbsp;Let me check it out
</div>


<div>
Pretty clever! Thanks for the help.
</div>


<div>
<div class="content wysiwyg-content">
As the title implies, I have a main form and a subform i.e frmMain, frmMain_sf with a Combo Box &nbsp;on the frmMain listing all of the records listed in frmMain_sf. The record source for the subform is a stored query with no record source for frmMain.<br />
<br />
I want to select a value in the Combo Box and go to that record on the subform. &nbsp;I would also like to highlight the record found in some manor i.e. different row color.<br />
<br />
Help anyone?
</div>
</div>


As the title implies, I have a main form and a subform i.e frmMain, frmMain_sf with a Combo Box  on the frmMain listing all of the records listed in frmMain_sf. The record source for the subform is a stored query with no record source for frmMain.

I want to select a value in the Combo Box and go to that record on the subform.  I would also like to highlight the record found in some manor i.e. different row color.

Help anyone?

MS Access 2013 Subform Search

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.