filter and sort a form

P

Papa Jonah

I have a form that I want to be sorted by a date field and filtered according
to a checkbox when it opens.
I know how to filter the form with the funnel-looking button - but Iwant to
do it automatically.
I used the datefield name in the "order by" property of the form - but that
did not work.

Any suggestions would be greatly appreciated.
TIA
 
D

Damon Heron

Open the form in design view and look at properties-data-record source.
Click on the (...) button to the right of your table name. This will help
you build a query. Select all the fields you want on the form and for the
date field, click sort Ascending. The checkbox field would be true or false
for the criteria. Now run the query to see if you get the expected results.
If it is okay then close and save your form.

HTH
Damon
 
Top