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
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