Hi,
I'm kinder of new to access and I need help finding out what is wrong with the following VB coding.
I created a report from a query to search a specific record based on analyst name
I created a search from and out combo box to select the name and it will display the report with the name called.
Private Sub Command2_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Search_Report"
stLinkCriteria = "[AnalystName]=" & Me![CboAnalyst]
stLinkCriteria = "[Analyst_Name]=" & Me![CboAnalyst]
DoCmd.OpenReport stDocName, , , stLinkCriteria
Exit_Command2_Click:
Exit Sub
The analyst name on the report is in this format(john smith). Im not sure if this is the reason why I'm getting this error message.
Please help