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

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

Similar Threads

continuous form & extra record 2
Prevent duplicate selection from combo box on continuous form 4
Ac2007 continuous form - expand on open? 4
Close popup form from a continuous subform 3
Continuous Form Issue 1
open record on one form from another form 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Change caption on continuous subform 3

Back
Top