Macro in form

[benwo]

Hi, hope someone can help!

I have a macro written that when clicked on it opens a web browser. Is there a way this can then point to a specific website url? I could make the default url in the browser point to a url but each time i click on the macro button the url needs to be different. all of the urls sit in a table within the database.

Hope this all makes sense!!

Thanks

B

 

[Rickster57]

Web

Did you try using a hyperlink?

 

[benwo]

yes but the problem there was each url is different. i can display the individual url's on the form but not sure how to turn that text box into a hyperlink after that

 

[Rickster57]

Can you (on a form) place a list box with these url's? Use the After Update Event of the List Box and set the hyperlink Address to that chosen URL..

me.hyperlinkaddress=me.listbox.column(0) ...or whatever

Does that help?

 

[benwo]

basically i want to click a button that goes and checks a column in a table for the correct url and then pops the browser with that url, any ideas?

 

[benwo]

it's a good idea but all the urls' (2000 of them) are similar so there would be too much confusion there i think. if a macro or command button could search a table for the correct url and then present it that would be awesome