<div>
Copy the query the subform is based on and call it something like &nbsp;qTRNX_TYPE_I<br />
Put <b>&quot;I&quot;</b> in the criteria of the TRNX_TYPE field<br />
Put <b>Is Not Null</b> in the criteria of the DATE_RECD field<br />
<br />
Then put a command button in the header of the subform that does this in the OnClick Event<br />
Me.RecordSource = &quot;qTRNX_TYPE_I&quot;
</div>


Copy the query the subform is based on and call it something like  qTRNX_TYPE_I
Put "I" in the criteria of the TRNX_TYPE field
Put Is Not Null in the criteria of the DATE_RECD field

Then put a command button in the header of the subform that does this in the OnClick Event
Me.RecordSource = "qTRNX_TYPE_I"

<div>
<div class="content wysiwyg-content">
I have a form that has a sub-form. &nbsp;When the form opens (with the subform), I want only certain records to display in the subform. that relate to the ID in the main form. &nbsp;<br />
<br />
For of all the link between the 2 form is ID. &nbsp;<br />
<br />
But I want the subform to display only the records that have TRNX_TYPE being &quot;I&quot; (letter I, not 1), and DATE_RECD is not null<br />
<br />
Its like the subform should open with: &nbsp;TRNX_TYPE = &quot;I&quot; AND DATE_RECD is not null<br />
<br />
How can I make the subform only display those records?
</div>
</div>


I have a form that has a sub-form.  When the form opens (with the subform), I want only certain records to display in the subform. that relate to the ID in the main form.  

For of all the link between the 2 form is ID.  

But I want the subform to display only the records that have TRNX_TYPE being "I" (letter I, not 1), and DATE_RECD is not null

Its like the subform should open with:  TRNX_TYPE = "I" AND DATE_RECD is not null

How can I make the subform only display those records?

How make subform display only certain 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.