Automatically Applying Advanced Filter / Sort

bridog39 · November 12th, 2005, 02:32 PM

I'm trying to sort the records of a form by an expression called
Val(ProvenienceNumber). The only way that I know how to do this is in Form view going to Records - Filter - Advanced Filter/Sort, entering the expression and filtering the records. How do I programatically get Access to do this on a OnLoad or OnOpen event so my clients don't have to do this every time they want to look at sorted records?

Thank you,

Brian

mmcdonal · November 14th, 2005, 08:55 AM

What is the record source of the Form? A query or table? If it is a query, then sort the query, and the form will reflect that sort.

mmcdonal

bridog39 · November 14th, 2005, 01:49 PM

The recordsource on this form is a table.

Quote:

quote:Originally posted by mmcdonal
What is the record source of the Form? A query or table? If it is a query, then sort the query, and the form will reflect that sort.

mmcdonal

mmcdonal · November 14th, 2005, 04:32 PM

You should be able to use the Order By field on the data tab of the form. Is this not working?

What are you doing by hand to filter the records? What expression are you entering?

mmcdonal

bridog39 · November 24th, 2005, 04:18 PM

Hi mmcdonal,

Instead of using the Val() expression, I changed my text field into two separate number fields, and am sorting the fields by the two number fields.

Thanks for your help, though!

Bridog39