How to Populate Hyperlink Field from ComboBox?

[Kathryn Birstein]

Hi,

I have a table of hyperlinks called "Websites" that contains just 2 text
fields:

Title - the name of the hyperlink, i.e. Microsoft Corporation
URL - the complete URL, i.e. http:\\www.microsoft.com

I would like to use this table as the query source for a hyperlink field in
a edit form for a table called "Activities". I setup the ComboBox so that the
Row Source is a Query:

SELECT Websites.Title, Websites.URL FROM Websites;

and then "2" for Column Count and "1" as the bound field and it seems to
work. The Title populates the field and is underlined. But when I try to
follow the hyperlink I see that it has simply copied the title into the URL
part of the hyperlink field as well. Can I use a ComboBox to populate both
parts of the hyperlink field?

Any help would be much appreciated!

Kathryn