i have a table with a field called "DESCRIPTION". this field is a hyperlink field. when i click on an entry it links to the doc on the server, no problems there.
i then have a form with a list box on it which is linked to the "DESCRIPTION" field, but when i click on an entry in the listbox it dont link to the doc.
any ideas please?

thanks in advance

Try using Application.FollowHyperlink Me.ListBoxName in the AfterUpdate event of the listbox

the reason it doesn't work is because a list box isn't a stacked list of hyperlinks, it's a list box(I think?).

Ian

sorry, i must be missing something here, surely the code you posted has to have the hyperlink address in it somewhere?
if possible could you please post the whole code as i am only a newbie.
thanks in advance

Application.FollowHyperlink Me.ListBoxName

is the whole code. Replace the "ListBoxName" part of Me.ListBoxName with the name of the ListBox control on your form.

i have done that but i just get a run time error saying
2147221014(800401ea):
application-defined or object-defined error

any ideas please