I am very grateful for your response, which I tried, but
unfortunately it still isn't working . . . I even tried asking for
the ListIndex values in a Msgbox and the values look to me like they
should work (i.e. if I clicked on a name down on the list, the
msgbox said that it was ListIndex 33 or whatever . . . but it still
didn't reset to that line, it still came back to the listbox
scrolled to the top with nothing highlighted, like it has reset to
ListIndex = - 1 . . . I did try the 'repaint' and it just kicked
back an error on compiling and wouldn't run.
I don't know what I'm doing wrong. Apparently, I must have
something else in the code interfering with that textbox change
event, as it connects to the listbox click event and the 'loadrow'
sub which takes whatever is highlighted in the listbox and puts it
into the textboxes. I stepped through it using F8 line by line and
when I did that, it highlighted the correct line in the
listbox! . . . Go figure.
Why it won't work when I'm running it straight doesn't make
sense. I'm totally lost, because everything I've read says it
should work.
Maybe I've hit the "other direction" of the same problem that
Lisa was working with, so to speak. Maybe I need more guidance on
the debugging part of it . . . ? . . . or mayby I've written too
much code so it goes back over it and changes it back to listindex
= -1 . . . which is how the listbox is loaded when the form is
intialized. Or, any and all of the above in a bad combination.
How do I debug that to find out? . . . or what else might I do
to get it to work?
At this point, I'm ready to submit an application for "dumber
than a post" in case anybody needs one. Anybody know a position
that's open for that, let me know. I'm probably missing something
obvious, but heck . . . it's a good thing that life is full of
variety.
And I've tried to recode it so many times, I really think that
someone smarter than I am needs to give me a new start to work
from. If I posted my present code now, I don't even know what was
the original nor what was one of the suggested . . . all I know is
that none of them worked.
I do hope someone laughs about this . . . I could use a "humor
is the best medicine' kind of laugh.