I have a report that generates links to external web pages by concatenating a base URL with a species ID. The species ID is stored in the data table, and the URL is built with the on-click event of a button.
Example:
Code:Private Sub ecosButton_Click()Code:If IsNull(Me.ECOScode) Then MsgBox ("Sorry, there isn't currently a species profile for " & CommonName & "."), vbOKOnly, "Warning!" Else txtURL = "http://ecos.fws.gov/speciesProfile/profile/speciesProfile.action?spcode=" & Me.ECOScode DoCmd.Hourglass True FollowHyperlink txtURL DoCmd.Hourglass False End If End Sub
All of a sudden when I click a link it creates a URL for the FIRST SPECIES IN THE REPORT as opposed to the species that I actually selected. I'm not sure what's causing this problem as it worked perfectly before. I'm trying to attach the database, but I can't seem to get it under the 2mb size limit (I'm sitting at 2.11), and 7-zip files are not supported.
Any suggestions?