Manage when subform is displayed

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
 
J

John W. Vinson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top