Displaying records based on fields in table

[matey56]

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?

[June7]

Can't. If field is not in Form1, how do you expect to apply filter? Actually, I am not really understanding described filter mechanism. If you want to provide db for analysis, follow instructions at bottom of my post.

[Gicu]

Can you replicate the calculation in the record source query of Form 1 (are the fields needed for the calculation included in that query)? If yes you're done, just apply the desired criteria to it.

Cheers,