If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Manage when subform is displayed
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 |
#3
|
|||
|
|||
Manage when subform is displayed
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] |
Thread Tools | |
Display Modes | |
|
|