filter and sort a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Papa Jonah - 23 May 2007 23:15 GMT

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

Reply to this Message

Damon Heron - 24 May 2007 00:11 GMT

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

>I have a form that I want to be sorted by a date field and filtered
>according
[quoted text clipped - 8 lines]
> Any suggestions would be greatly appreciated.
> TIA

Reply to this Message