I am trying to display information for a UPS tracking number by double clicking on the tracking number on a subform in Access 2010.
I have the following code on the double click event for the tracking number field:
Private Sub Tracking_Number_DblClick(C
ancel As Integer)
UPSID = "C:\Program Files\Internet Explorer\IEXPLORE.EXE http://wwwapps.ups.com/WebTracking/track?loc=en_US&ID=
" & Tracking_Number
X = Shell(UPSID, vbMaximizedFocus)
This code brings up the UPS Tracking site but it does not fill in the Tracking Number and display information for it. Is there a way to do this?