How to open web page from a command button 1

[src2]

I've looked at some posts and some books but haven't found a solution thus far. What I have is a table with a field called link containing a web address. It is defined as a hyperlink field. I have an unbound main form called frmBillOverview and a subform called sfrmBills. The subform's record source is based on a query that includes link and other fields. On the main form I have several fields whose control source comes from the subform (for example PaymentMethod is set to =[sfrmBills].Form!PaymentMethod). What I want to do is create a command button that when clicked will launch the website address stored in the link field. Can anyone point me in the right direction or refer me to a solution that spells it out for someone who isn't very good at access?

Thanks a lot!

 

[PHV]

Why not using the Follow method of the Hyperlink object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[src2]

Thanks! That did just what I wanted. I didn't use it because I had never heard of it before. Thanks again!!