List Box with Record Count

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

I am looking to create a list box on a form with a record count in it, the
format is

1 of 3
2 of 3
3 of 3

etc based on the number of record being retruned

also the user should be able to select an item from the list box and that
row should be selected
 
OK that was just plain dumb by me,

but now I need it to go to the selected record so if I select 2 of 2 then it
should go to that record
 
something like this:

set rst= me.recordsetclone
rst.movefirst
for i = 1 to left(MyListBox,1)
rst.movenext
next i
me.bookmark=rst.bookmark

of course you also need to add code that will prevent possible errors

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Back
Top