hyperlinks

[Brian Campbell]

I have a desktop Access application which has a combobox with a list of
my customers to choose from. My goal is to store a hyperlink to their
website in my customer table. What I want to happen is when the user
chooses a company, its associated hyperlink variable will launch
internet explorer automatically and go to their website. Any clues
on how to make this call programatically? (Of course I'd put in error
handling, is IE running already?, close previous ie window, etc.)

As an added feature, I'd like to have the hyperlinks reside in a
separate table for more secure maintenance as the hypers to pages can
be quite long. I'd like to have maybe a 9-digit number in my customer
table that is linked to its corresponding hyperlink in the hyperlink
table.

Example: Ajax Loan Corp. = # 854521437 (unique number) =

854521437 = "http/blahblahblah
..ajxcrp/faq/hrfd&and%flemingdesk%23%58%minusAjax/local/%cap .asp"

The reason I'd want a unique number for the client linking the hyper is
that maintenance would require just pasting my customer's emailed hyper
into the file # 85421437

Thanks for any clues! Brian