Access - call web address from button on form

[wakeywakey]

Hi

On a form, I'd like to have a button to press that generates a web address with a variable equal to a field on the form e.g.

http://www.website.com/gerbil.htm

where gerbil is in the field animal and it's visible on the form being displayed. I currently have extra fields set up of type hyperlink, and maintain these links but I make mistakes and I'm depriving the software of work it could do...

Thanks

wakey

 

[wakeywakey]

See Microsoft: Access Modules (VBA Coding) for the answer...