This should be simple but so far I can't find the trick. I have a
sharepoint document library that is linked to Access 2003 database. I
would like to populate a listbox or combo box with the names of the
documents as they are hyperlinks. This all works, very simple. The
problem is that the listbox seems to strip the hyperlink property to
where I can't follow the hyperlink when I click. If I do the exact
same query I get the list I want and it will follow the hyperlinks. I
am using unbound controls that are set through VBA code. The reason
for wanting to use combo/list boxes is that eventually the documents
could be numerous enough that I would need to have search capability.
I can get the thing to work if I make a bound form, it uses text boxes
but then it requires record navigation. This form needs to hit 2
seperate document libraries based on an option group. The code works
for populating the boxes with the names...just no hyperlink. What am I
missing?
|