Requery Issue 1

[Taff82]

Hi all,

I have a a form with a listbox on. When I click a command button it opens a form depending on what I have selected in my listbox.

When the listbox is requeried it automatically selects the top record from my listbox. It is possible to requery the listbox but keep the record I originally had selected - Selected?

Thanks

Taff

 

[KenReay]

Hi

How about:

Dim SavedSelection

SavedSelection = MyListBox
MyListBox.requery
MyListBox = SavedSelection

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Taff82]

Hi Ken,

Thanks for the reply, unfortunately it still selects the top value of the listbox.

Regards,

Taff

 

[TheAceMan1]

How are ya Taff82 . . . . .

Try this:

[blue]Dim LBx As ListBox, idx As Long

Set LBx = Me![purple][b]YourLisBoxName?[/b][/purple]
idx = LBx.ListIndex

LBx.RowSource = LBx.RowSource [green]'requeries with no selection[/green]
LBx.Selected(idx) = True[/blue]

See Ya! . . . . . .

 

[Taff82]

Thanks AceMan,

Works great, exactly what I was after.

Taff.