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

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" <(E-Mail Removed)> wrote in message
news:FC79E251-D133-4F34-A859-(E-Mail Removed)...
>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,

where would I put the code?



"Alex Dybenko" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:FC79E251-D133-4F34-A859-(E-Mail Removed)...
> >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

"Alex Dybenko" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:FC79E251-D133-4F34-A859-(E-Mail Removed)...
> >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
>
>

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


"Nigel" <(E-Mail Removed)> wrote in message
news:28AF1BE1-68E7-4336-B91D-(E-Mail Removed)...
>
> 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" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:FC79E251-D133-4F34-A859-(E-Mail Removed)...
>> >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
>>
>>