SQL query from form, and hyperlinks

[jakesups]

Help, here is my problem. From a form of server information I want to display a list box with a variable amount of items. (procedures on how to do things with this server) These items will also be hyperlinked to files stored on the system.
1. how do I create a select query so that the list box is populated with only the items which pertain to that server. Here is my attempt...
SELECT [servers-Hyperlink].[HyperlinkAddress] FROM [servers-Hyperlink] WHERE [servername]=[Forms]![servers-Hyperlink]!servername;
I assume it should be bound somehow to the form, but I'm really not sure.
2. Eventhough I have designed the HyperlinkAddress as type hyperlink, it won't launch. How should I fix this?

I'm a bit of a newbie at this still. I appreciate anyones help.
thx, Jim

 

[jakesups]

I still need some guidance with this if there's anyone who understands what I'm trying to do. I don't think it's that complicated, I'm just inexperienced with VB still.

Thanks again, Jim