How to filter a list of Hyperlinks?

[sportzrule]

I have a database with many enteries, most of the enteries have
hyperlinks that link to the document the entery was pulled from. It is
setup so you can click the hyperlink, it opens the document and you can
get more information if needed.

I currently search for enteries by, filling out combo boxes on a form,
click a button that runs a query, the query matches the choices a user
picked to the enteries and displays on another form all the enteries
that match all teh combo boxes the user selected. This works great
until I tried it with hyperlinks. I can't seem to figure out why. Any
help would be appreciated, and other means of filtering a list of
hyperlinks is also welcome.

Thanks in advance!

 

[strive4peace]

I like to store path\name as text instead of hyperlink. Then you can do
this:

application.followhyperlink strVariable

application.followhyperlink [strControl]

application.followhyperlink "c:\data\document.doc"

for filtering on records that have something filled out:

field --> len(trim(nz([fieldname],"")))
criteria --> >0

also, as text, it will be easier to do comparisons

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*