Show Only non Complete workorder in form

[resg60]

I have a Maintenance work order form I would like to filter out completed records so when the form is open it will only show workorders that need to be copleted and also a way to view all the workorders that are complete

Thanks

 

[Rickster57]

Checkbox

Without knowing how you designate a finished workorder here is one possible solution. If you have a field in your table called completed (say using a check box) you could set your query (that your form is using) to only show orders where completed is YES. So in your query under criteria for the completed field use -1 for completed and 0 (zero) for uncompleted.

 

[resg60]

I do have A checkbox for complete My problem is I do not understand how to create the query and initiate it to open the form.

 

[Rickster57]

checkbox

If the field in your table is called IsComplete then create a query using the table. Drop all your table fields into this query. In the Criteria under IsCompleted set the Criteria to -1 for complete. Run this query and you will see only Completed Orders. Create a form using this query as it's RecordsSource.

 

[resg60]

Thanks I now have a main form that has links to either complete or not complete workorders