Manage when subform is displayed

I am making a form for scientific data entry regarding sample processing. I
have made a subform to include detailed information on positive samples, but
would like to subform to only display for records where either one of two
fields in the original form (call them "A" and "B") is non-zero.

As things are, the subform displays for every record, and as a result
information is sent to my "Positive Results" table for every record rather
than just the positive ones. If there is a way to stop this from happening
without hiding the subform for negative results, that would be helpful too.

Thanks,
Katherine

Never mind about the second part of the post, I was wrong about that.

"Katherine" wrote:

I am making a form for scientific data entry regarding sample processing. I
have made a subform to include detailed information on positive samples, but
would like to subform to only display for records where either one of two
fields in the original form (call them "A" and "B") is non-zero.

As things are, the subform displays for every record, and as a result
information is sent to my "Positive Results" table for every record rather
than just the positive ones. If there is a way to stop this from happening
without hiding the subform for negative results, that would be helpful too.

Thanks,
Katherine

On Fri, 29 Aug 2008 14:06:01 -0700, Katherine
wrote:

I am making a form for scientific data entry regarding sample processing. I
have made a subform to include detailed information on positive samples, but
would like to subform to only display for records where either one of two
fields in the original form (call them "A" and "B") is non-zero.

Base the Subform on a Query with a criterion of True on A and B (on separate
lines on the query grid to use Or logic).
--

John W. Vinson [MVP]