Repost: Can this be done?

M

Me

Please read from downup, I had sent this question on 7/21 earlier on and I got
replies from couple of users - thanks.

Here is my observation and questions that came up -

-------------
This is what I found, if I have it the way you described, then when I query
something in subform b, then it does filter the results, but it shows blank
records where the data doesn't match subform b search criteria.

Similarly, it leaves blank when the search crietria in form c doesn't match.

Is there any way by which I can restrict it to skip those records when the
search criteria doesn't match?

I mean it shows all the records at all times, just leaves the form (main or
subform)
blank for records for which the search criteria doesn't match.

I would like it to skip those records.

Thanks for your help!

-Me
 
Top