Re: Sort order in form issue
- From: fredg <fgutkind@xxxxxxxxxxxxxxx>
- Date: Tue, 22 Nov 2005 13:10:07 -0800
On Tue, 22 Nov 2005 12:59:05 -0800, TonyL wrote:
> I have a form that displays contact details from a table. When I do a search
> on any field using the standard search button & want to scroll thru the
> records, it sorts by the RecordID field which is the primary key field. In
> the form properties I have defined the Sort Order by:
>
> tblContact.LastName, tblContact.FirstName
>
> But it still scrolls thru using the Record ID. This is a pain where I am
> search for say LastName is Smith. Where am I going wrong? TIA
It's not enough to set a Sort order.
You must then right-click on the form and select Apply Filter/Sort.
A better solution if you always want to display the records in
LastName, FirstName order would be to create q query, sorted according
to LastName, FirstName. Use the query as the form's record source.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.
- Prev by Date: Re: Continuous Form Question
- Next by Date: Re: Prompted as though doing a param query on closing form
- Previous by thread: Re: Hide system tables in mdb created with CreateDatabase method
- Next by thread: How To ......
- Index(es):
