how to use a field value in hyperlink?

[Guest]

Im trying to have a button to where when pressed it goes to a url. However,
I am needing it to take a textbox entry to complete the URL. Such as:

The final URL would like like this:
//videosrv/directory/directory/b[textboxentry]/plans

Then it would go to that [textboxentry]'s folder on the server.

Can you help?

 

[fredg]

Im trying to have a button to where when pressed it goes to a url. However,
I am needing it to take a textbox entry to complete the URL. Such as:

The final URL would like like this:
//videosrv/directory/directory/b[textboxentry]/plans

Then it would go to that [textboxentry]'s folder on the server.

Can you help?

Use a normal text datatype field for this, not a hyperlink field.
On the form, code the control's Double-click event:

Application.FollowHyperlink "//videosrv/directory/directory/b" &
[textboxentry] & "/plans "