<div>
<div class="content wysiwyg-content">
I'm using this code in an attempt to open a form to display only records where InventoryType is 1. &nbsp;It is not working. &nbsp;I get an error...<br />
<br />
Database can't find the field '|1' referred to in your expression. &nbsp;<br />
<br />
<br />
DoCmd.OpenForm &quot;frmInventoryRecordsInboun<wbr />d&quot;, acNormal, , [InventoryType] = 1, acFormEdit, acWindowNormal
</div>
</div>


I'm using this code in an attempt to open a form to display only records where InventoryType is 1.  It is not working.  I get an error...

Database can't find the field '|1' referred to in your expression.  


DoCmd.OpenForm "frmInventoryRecordsInbound", acNormal, , [InventoryType] = 1, acFormEdit, acWindowNormal

Trying to open form to display certain types of records

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.