You're right, June7, I don't know how I missed that!
I'm having a bit of trouble with the SQL syntax. As I understand it, when I click on the item, in the instance below, a text field, it should open my report filtering on the specified record. But what happens is a dialogue box pops up asking for me to enter 'txtRecipeName'. If what I type matches something, ALL my recipes are displayed. If it doesn't match anything, then a blank record is displayed (both in report view, though).
Also, please see the attached database. Thanks for all your help! I really appreciate it.
Code:
Private Sub txtRecipeName_Click()
Dim Name As String
Name = Me.txtRecipeName
DoCmd.OpenReport "rptRecipeList", acViewReport, , "txtRecipeName = '" & Name & "'"
End Sub
Attachment 19555