Manage when subform is displayed

  • Thread starter Thread starter Katherine
  • Start date Start date
K

Katherine

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
 
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.
Click to expand...

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).
 
Back
Top