List Box with Record Count

[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

 

[Alex Dybenko]

Hi,
something like this

RecCount=me.recordsetclone.recordcount
for i= 1 to RecCount
MyListBox.AddItem Item:=i & " of " & RecCount
next i


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

 

[Nigel]

Alex,

where would I put the code?

Hi,
something like this

RecCount=me.recordsetclone.recordcount
for i= 1 to RecCount
MyListBox.AddItem Item:=i & " of " & RecCount
next i


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

 

[Nigel]

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

 

[Alex Dybenko]

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