Listbox Sorting

T

The-Movie

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
 
N

noeraett

Fixed it myself, changed rs.MoveFirst to rs.Requery
and it worked

The-Movie skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter report with Combobox AND Multiselect Listbox 2
Adjustable Listbox 2
Listbox not populating every time 1
Listbox, Dropdownbox, Data in one column not visible 2
listbox doesn't store value 1
Simulate "autoselect" in ListBox 5
sorting of a2000 listbox contents 5
Listbox Source 2

Top