filtering

[twixx]

Hello Access Whiz's!

I would like to create a filter for a form depending on whether the subform has any data in it. Is it possible to create a filter of some sort or would there be another method to do the same thing?

I don't know if it's helpful to mention this, but basically the form shows information in the master table and the subform shows information from a related table that's connected with a one-to-many relationship.

I would also like to do something similar with a report. Any ideas?

Thanks!