J junmart Registered User. Local time Today, 04:03 Joined Sep 14, 2001 Messages 29 May 29, 2002 #1 Is it possible to sort the data in a continous form based on the header clicked by the user? thanks for any help.
Is it possible to sort the data in a continous form based on the header clicked by the user? thanks for any help.
P Peter D Registered User. Local time Today, 04:03 Joined Sep 7, 2000 Messages 188 May 30, 2002 #2 Yes, it's possible. One way to do this is to update the underlying recordsource sql for the continuous form - change the ORDER BY clause to include the field you want to sort on. Then requery the continuous form. Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com Selector for MS Access http://www.peterssoftware.com/sel.htm
Yes, it's possible. One way to do this is to update the underlying recordsource sql for the continuous form - change the ORDER BY clause to include the field you want to sort on. Then requery the continuous form. Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com Selector for MS Access http://www.peterssoftware.com/sel.htm
