I have a table which holds a field named SupplierName and ProductLink. Inside an existing form I would like to have a listbox which uses the SupplierName as the item text and the ProductLink as a hyperlink for that item. The user should therefore be able to clink on any of the supplier names in the listbox and the link to the product will open in the webbrowser.
How do I do that? I assume that I first have to write some VBA code that takes both the SupplierName and the ProductLink and creates the list item which is added to the list. Any hints on how to do this? Is the listbox even able to have links as items?
Thank you for your help.
~ Tectu