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
 

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

List Box Record Count 2
Counting multiple memberships 1
Record insert/delete anomaly 0
populate a text box with multiple records based on combo box selec 2
Going Nuts with Selecting the Value of List Box using an unbound TextBox 11
Focus in a list box 4
Finding a record with composite key 6
Creating a query using multiselect list box and text boxes 20

Back
Top