Hi,
Does anyone know a way, through code, to cause/force a click on a column
heading for a variable lookup listview control on a form?
- My form has a variable lookup listview control with multiple columns,
along with headings for the columns.
- When the form is opened and the selected rows are displayed, they are
sorted in ascending order by the contents of the first column.
- The user may click on any other column to resort the displayed rows by
ascending or descending order.
- The user can enter new selection criteria through variables above the
listview on the form, then click a button to update the selection of the rows
displayed in the listview control.
- When the new records are displayed in the listview control, I want to
force the sort order to be sorted in ascending order by the first column.
- The code I'm using to try to reinitialize the sort order when the list is
refreshed is:
SET VAR vWhere = (some selection criteria) & 'ORDER BY col1name ASC'
PROPERTY var_component_ID REFRESHLIST 'true'
What I'm finding is if the user had previously clicked on some column
other than "col1name", the records displayed by the refreshlist stay sorted in
that previous order rather than by "col1name ASC".
What am I doing wrong? Is there a way to force the resort by code?
Thanks in advance,
Diane DeMers
[email protected]
DeKalb, IL
