field needs to be in order...

[stephendeloach via AccessMonster.com]

when i open my form it has a subform. in the subform there is a Vendor field.
how can i make it to when i open the form the Vendor field is already in abc
order. Every time i open it i have to click the A-Z button... Thanks

 

[John W. Vinson]

when i open my form it has a subform. in the subform there is a Vendor field.
how can i make it to when i open the form the Vendor field is already in abc
order. Every time i open it i have to click the A-Z button... Thanks

Open the form you're using as a subform in design view, and View its
Properties. The first property on the Data tab is the Recordsource - I'm
guessing it's now just the name of a table.

Click the ... icon by it, and accept Access' offer to change it to a Query.
Add all the fields from the table to the query grid, and use the Sort line to
sort the records as desired. Close the query window and accept Access' offer
to change the recordsource.


John W. Vinson [MVP]

 

[Pete D.]

Depends on the source, is it a query or table. If it is a query add the
sort to the query.