Listbox Sorting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "The-Movie" <noeraett@xxxxxxxxx>
Date: 19 Jul 2006 01:50:38 -0700

Hi i have a problem, i cant seem to get my listbox not to sort the
data.

this wouldn't be a problem if it wasn't for this bit of code i use:

Me.Form.Refresh
a = Me.ListBox.ListIndex
Set rs = Me.Recordset
rs.OpenRecordset
rs.MoveFirst
rs.Move (a)

I use this for filling out some textboxes to use for editing the data
selected in the listbox. But because the listbox gets sorted it's
impossible to get the right data for the text boxes.

i haven't got any sorting in the query that fills the listbox

.

Follow-Ups:
- Re: Listbox Sorting
  - From: noeraett

Prev by Date: Date in bussines objects sql code
Next by Date: Re: Listbox Sorting
Previous by thread: Date in bussines objects sql code
Next by thread: Re: Listbox Sorting
Index(es):
- Date
- Thread

Relevant Pages

Re: ACC 2002: Sort a ListBox with no SQL rowsource
... >ListBox. ... Sort list box by column when column is ... Dim vGetWidths As Variant ... Dim iLoop As Integer ...
(microsoft.public.access.formscoding)
Re: Sorting listbox contents
... Sort list box by column when column is right-clicked ... 'Install call to this code in the Mouse Down event of a listbox. ... Dim iLoop As Integer ... MsgBox "List box must use a query as it's row source" ...
(microsoft.public.access.modulesdaovba)
Re: ACC 2002: Sort a ListBox with no SQL rowsource
... then sort the array. ... >algorythm to sort my listbox where my listbox does not ... >have a SQL statement or Query for it's RowSource; ... >>Dim vGetWidths As Variant ...
(microsoft.public.access.formscoding)
Re: ACC 2002: Sort a ListBox with no SQL rowsource
... algorythm to sort my listbox where my listbox does not ... have a SQL statement or Query for it's RowSource; ... >>would like to do is sort the list Ascending order after ... >Dim vGetWidths As Variant ...
(microsoft.public.access.formscoding)
Re: ACC 2002: Sort a ListBox with no SQL rowsource
... favourite sort routine to sort that array, ... > algorythm to sort my listbox where my listbox does not ... > have a SQL statement or Query for it's RowSource; ... >>Dim vGetWidths As Variant ...
(microsoft.public.access.formscoding)