listview box find row number

[cfinch100]

hi
I have a listview box that populates textboxes,i have put a textbox19 on the uaerform to get row number,if you enter h555 in search and click find
there are about 12 instances of it and tb19 says row 39,which is right,but if I click any other row this goes back to zero,have tried doing a loop but this crashed the program,any ideas please,i had one for listbox that worked but seems listview is different
cheers colin

[xladept]

Hi Colin,

I looked at this and it's choking on:

Please Login or Register  to view this content.

rngRec is not Set or defined and there is no data in the first row??

(Just a quick perusal)

[cfinch100]

hi xladept
thanks for looking,have gone through code and can not find

Please Login or Register  to view this content.

this at all i
must be missing something
cheers colin

[xladept]

It's in the Form code:

Please Login or Register  to view this content.

*I added the Me in front of .Controls

[cfinch100]

hi xladept
found it my old eyes not as good as they were,tried to define as range but keeps stopping on

Please Login or Register  to view this content.

,had gone with listview so could have 13 columns in box as opposed to listbox,wish I had nt now
cheers colin

[Norie]

Colin

You can have 13, or more, columns in a listbox.

If you are having problems with that then it's probably to do with the way you are populating the listbox.

PS Have you considered giving your controls more descriptive names?

[cfinch100]

hi norie
been here before norie ,yes I will do that right now
cheers colin

[cfinch100]

hi norie
this was my first option but could not get listbox to populate all 13 columns,any pointers would be good
cheers colin