Hi All

I have a layout linked to a table for "To do" items. Each record has a due date field (in date format) and a done field (a simple yes tickbox). I would like the layout to only show items which are not done (ie do not have a tick in the yes box) and in Due Date order. I am using the List View for the form.

Is this possible?

John

I would change your Done field to Completed and store the date (more meaningful).

Just Find records where Completed date is empty. (Enter Find mode and type "=" in the Complete field).

Sort records by Due Date ascending or descending.

Ok I understand. Thank you