Visual Basic Forum for Visual Basic Programmers VB

[SKP]

I'm trying to set up a way that will allow me to enter a name and click a button to show a popup form of detailed information for an individual. I was hoping someone could help me figure out what I am doing wrong because I keep getting a syntax error when I click on my command button. I'm new to visual basic and trying to learn as I go, so any help will be greatly appreciated. I've attached a copy of the code where I'm having trouble.

Sub FormPic1_Click()
On Error GoTo Err_FormPic1_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Studio Director Detail Form"
stLinkCriteria = "[StudioDirectorName] = " & Me![StudioDirectorName]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_FormPic1_Click:
Exit Sub

Err_FormPic1_Click:
MsgBox Err.Description
Resume Exit_FormPic1_Click

End Sub

[Andir]

Is the link criteria in the "Filter" variable location? I don't have a version of access available right now, will have to check when I get to one. If it is...try this:

stLinkCriteria = "StudioDirectorName=" & StudioDirectorName

PS: make sure the Form your loading doesnt have anything in the OnFormOpen that clears the filter...I think it's DoCmd.acClearFilter or something like that.

Edit: Can we move this to the VBA section? Since it does deal with that.
_________________
If you happen to see little people sitting on your desk...don't tell anyone or they might think your crazy too.