After save, move to next row in listbox. 1

[ponderdj]

Hello,

I have a fairly simple question, I think. I have a listbox that sets the recordsource of the form when the user clicks on a row. When the user saves certain changes, the record on the row they selected no longer meets the criteria for the listbox and when the listbox requries after the save, the row is dropped. How can I make the focus drop to the next line in the listbox?

Thanks

 

[PHV]

Save the ListIndex property of the listbox before the requery:
With Me![listbox name]
intOldIndex = .ListIndex
.ReQuery
.SetFocus
.ListIndex = intOldIndex
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ponderdj]

Ahh, ListIndex. That's what I was looking for. Thanks PHV.