And the funny thing is I overlooked one thing that maybe the root of my problem. I kept trying to use the values in the class module SearchResult. Saying object required.
So I added this to my more sub:
So now I can access all the values in SearchResult.Code:Dim sr As SearchResult Set sr = colSearches(Text1.Text)
Going to now try a new sub and report back.




Reply With Quote