Re: append contents of field to another field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"RipperT @comcast.net>" <rippertsmith<nospam> wrote in message
news:erANMbFSFHA.3296@xxxxxxxxxxxxxxxxxxxx
>> It's easy enough to do, but why do it?
>
> I have field two in a form with a button next to it whose On_click
> event contains this:
>
> Application.FollowHyperlink Me.Field2, , True
>
> If I create a query with the concatenation, how will I adjust the
> above line of code to open the link? And, I'm thinking it will be
> slower in opening, too, but maybe not. What do you think?

I agree with everything Rick Brandt has posted in this thread. As an
alternative, if both Field1 and Field2 are present in your form's
recordsource, you could -- without changing anything else -- change the
line of code you posted above to this:

Application.FollowHyperlink Me.Field2 & Me.Field1, , True

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages