open a continuous form with only certainrecords showing

  • Thread starter Thread starter bobbie
  • Start date Start date
B

bobbie

I would like to create a continuous form that everytime
it is opened, it will only show certain records

I want it to show only uncompleted items
 
Create a query as the form's recordsource, and use a criterion that selects
only the records that have the "not completed" field (you do have that
field, right?) value of True. (Or the "Completed" field value of False.)

If you can provide more info about your table's structure and how you define
when a record is not completed, we can suggest some more specific ways to do
this.
 
that worked - thank you


-----Original Message-----
Create a query as the form's recordsource, and use a criterion that selects
only the records that have the "not completed" field (you do have that
field, right?) value of True. (Or the "Completed" field value of False.)

If you can provide more info about your table's structure and how you define
when a record is not completed, we can suggest some more specific ways to do
this.
--
Ken Snell
<MS ACCESS MVP>




.
Click to expand...
 
Back
Top