SubForm Question

S

scott04

I have a form that a manager enters in a schedule for their agents. Once the
manager enters the data they click on a command button. The button on click
refreshs the subform and places it in the schedule. My question is once this
projects are complete is there a way that the subform does not pull up
completed items? Thanks
 
L

Linq Adams via AccessMonster.com

You need to have a way to designate a closed project. Usually for this kind
of thing we use a checkbox bound to the underlying table. When the project is
completed, the box is checked. In the query that acts as the Record Source
for your subform, under the criteria for the checkbox field, place 0 (zero.)
When the subform refreshes (I'm assuming it's actually requerying) the query
won't return records that are marked as completed.
 
Top