Selecting Data from Form to be used in running an application

[Jim]

I'd like to use the 'Event' function, double click on a form control, grab
the currently displayed data in the control, insert that data in running the
following application. The data would follow the "callsign=" in the code
below. I am using Access 2002, WinXP.

Dim stAppName As String

stAppName = "C:\Program Files\Internet Explorer\iexplore.exe
http://www.qrz.com/database?callsign="
Call Shell(stAppName, 1)

 

[SusanV]

Dim stAppName As String
Dim csign as String
csign = Me.YourControlName

stAppName = "C:\Program Files\Internet Explorer\iexplore.exe
http://www.qrz.com/database?callsign=" & csign
Call Shell(stAppName, 1)

 

[Jim]

Thank you SusanV.
--
Jim Ory

Dim stAppName As String
Dim csign as String
csign = Me.YourControlName

stAppName = "C:\Program Files\Internet Explorer\iexplore.exe
http://www.qrz.com/database?callsign=" & csign
Call Shell(stAppName, 1)

 

[SusanV]

Glad to help

Thank you SusanV.