Hi all,
I have a form (we'll call it Form1) that I built and it only shows records where certain criteria are met in a related form (Form2). For example, if Field1 is null and Field2 is not null display the record). It works great. I just go into the design view of the query Form1 is based on and change the criteria of the field in the table to Is Null/Is Not Null.
Here's the tricky part.....Form2 has a calculated field that's only displayed on the form and data isn't stored in any table. If I want to to build a criteria in Form1 that says if this calculated field Is Not Null display the record, how do I do that?