<div>
Solved it. &nbsp;I found code in the 2nd forms on current event.<br />
<br />
Me.FilterOn = False<br />
<br />
Don't know why it was there.
</div>


Solved it.  I found code in the 2nd forms on current event.

Me.FilterOn = False

Don't know why it was there.

<div>
<div class="content wysiwyg-content">
I'm trying to open a specific form's record via a double-click event on another form. &nbsp;Here are the things I've tried but no matter what code I use, the form opens to the first record.<br />
<br />
DoCmd.OpenForm &quot;frmClients&quot;, , , &quot;[ClientID]=&quot; &amp;&nbsp;Me.txtClientID<br />
and<br />
DoCmd.OpenForm &quot;frmClients&quot;, , , &quot;ClientID = &quot;&nbsp;&amp; Me.txtClientID<br />
and<br />
DoCmd.OpenForm &quot;frmClients&quot;, WhereCondition:=&quot;ClientID=<wbr />&quot; &amp;&nbsp;Me.txtClientID<br />
<br />
What is wrong with this?
</div>
</div>


I'm trying to open a specific form's record via a double-click event on another form.  Here are the things I've tried but no matter what code I use, the form opens to the first record.

DoCmd.OpenForm "frmClients", , , "[ClientID]=" & Me.txtClientID
and
DoCmd.OpenForm "frmClients", , , "ClientID = " & Me.txtClientID
and
DoCmd.OpenForm "frmClients", WhereCondition:="ClientID=" & Me.txtClientID

What is wrong with this?

Open a specific form's record via a double-click event on another form

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.