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?