<div>
This worked...<br />
<br />
DoCmd.OpenForm &quot;frmAssetRoomDetails&quot;, acNormal, &quot;&quot;, &quot;[AssetN] =&quot; &amp;&nbsp;Me.txtAssetN, , acNormal<br />
<br />
Thanks!
</div>


This worked...

DoCmd.OpenForm "frmAssetRoomDetails", acNormal, "", "[AssetN] =" & Me.txtAssetN, , acNormal

Thanks!

<div>
<div class="content wysiwyg-content">
I have a command button on a form which when clicked is supposed to open a second form to a specified criteria. &nbsp;Here is my code. &nbsp;But it isn't working. &nbsp;The second form is opening instead to the first record in the record source. &nbsp;If a record doesn't exist yet for AssetN then the form is to open for a new record entry.<br />
<br />
DoCmd.OpenForm &quot;frmAssetRoomDetails&quot;, acNormal, &quot;&quot;, [AssetN] = Me.txtAssetN, , acNormal<br />
<br />
???
</div>
</div>


I have a command button on a form which when clicked is supposed to open a second form to a specified criteria.  Here is my code.  But it isn't working.  The second form is opening instead to the first record in the record source.  If a record doesn't exist yet for AssetN then the form is to open for a new record entry.

DoCmd.OpenForm "frmAssetRoomDetails", acNormal, "", [AssetN] = Me.txtAssetN, , acNormal

???

Form isn't opening to specified record

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.