Open Filtered report from Hyperlink

[barter27293]

I have got a report with a list of names and I want to make them hyperlinks, so that when clicked on they open another report in a window showing all the entries in the database filtered under their name.

I have tried using the DoCmd.OpenReport command and presently it just opens the report with a blank page.

Here is the code I have at the moment for the hyperlink:

Private Sub Name_Click()
DoCmd.OpenReport "Individual list", acViewPreview, , "[Name]= 'Me.Name'"
End Sub
 

I am sure it is just a silly error somewhere, but I cant seem to sort it!

Many thanks in advance.

Kieran

[zmbd]

Private Sub Name_Click() 
DoCmd.OpenReport "Individual list", acViewPreview, , "[Name]= '" & Me.Name &"'" 
End Sub

Need to enclose the string portion of the criteria so that the form control value is available.

You've hit on two issues here:

Access 2007 reserved words and symbols
"Name" is one such reserved word and might cause you some issues.

Second:
You've stumbled upon one of my pet peeves by building the criteria string within the command - and it's not your fault because that's how a majority of examples show how to use the command.
Instead I suggest that you build the string first and then use the string in the command. Why you might ask, because you can then check how the string is actually resolving; thus, making troubleshooting the code so much easier as most of the time the issue is with something missing or not resolving properly/as expected within your string.

(some code omited...)
DIM strSQL as string
'
strSQL = "[Name]= '" & Me.Name &"'" 
'
'now you can insert a debug print here for troubleshooting
' - press <ctrl><g> to open the immediate window
' - you can now cut and paste this information for review!
'
debug.print "Your criteria = " & strSQL
'
'now use the string in your code:
DoCmd.OpenReport "Individual list", acViewPreview, , strSQL

[barter27293]

Thanks for that - it was just the reserved word 'Name' that was causing the issue... sorry I'm not that experienced with access - just trying to pick it up as I go along!

thanks again :-)

[zmbd]

Those nasty little keywords are a Gremlin for many people. The other is using spaces. Although technically allowed under the newer programs and operating systems, you'll find that if you need to upgrade to a larger database (SQLServer, MySQL, Oracle, etc...) that the spaces may also cause issues.


My Pleasure. We were all at the bottom of the learning curve at some point! Please keep us in mind should you get stuck again.