Change Order By property and requery not working
From: Ken Smith (anonymous_at_discussions.microsoft.com)
Date: 08/10/04
- Next message: anonymous_at_discussions.microsoft.com: "messages when I run a macro"
- Previous message: rt: "ADODB connection creates error; using Microsoft.Jet.OLEDB.4.0 as data provider"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 10 Aug 2004 16:05:51 -0700
Thanks, Allen, but I don't see an OrderByOn property in
the form's properties window. Where goes I to do that?
>-----Original Message-----
>After you SetValue the OrderBy property of the form, did
you SetValue the
>OrderByOn as well?
>
>--
>Allen Browne - Microsoft MVP. Perth, Western Australia.
>Tips for Access users - http://allenbrowne.com/tips.html
>Reply to group, rather than allenbrowne at mvps dot org.
>
>"Ken Smith" <anonymous@discussions.microsoft.com> wrote
in message
>news:398201c47ef8$56921560$a401280a@phx.gbl...
>>I have a continuous form displaying data that I want to
>> let the end user sort, based on the value of an options
>> frame. When the value in the frame is changed, a macro
>> (successfully) changes the Sort By property of the form
>> to the desired field name. The macro then requiries the
>> form, but the data remains unsorted.
>>
>> Any greater gurus out there have any idea what I'm
doing
>> wrong?
>>
>> -- Thanks.
- Next message: anonymous_at_discussions.microsoft.com: "messages when I run a macro"
- Previous message: rt: "ADODB connection creates error; using Microsoft.Jet.OLEDB.4.0 as data provider"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
