Retrieving field value from current record -> syntax error

[achroiet002]

Hi,

Please, can someone help me? My problem:
I have put a command button onto a form, which retrieves two field values from the current record. With these two values, I am able to open a document from Access.
Default value of field "documentna me" is "x"
Running the code, I get a syntax error
The code:

Private Sub Knop46_Click()
 
Dim path As String
Dim name As String
path = "c:\Documents and Settings\Test\My Documents\Docs\"
name = Trim(Me!documentname)
If name="x" <------ here I get a syntax error!
Then
MsgBox "No filename present (x = no name exists)"
Else
Application.FollowHyperlink [path] & [name]
End If
End Sub
 

[Rabbit]

Please use code tags.

Both path and name are reserved keywords in Access/VBA. You should rename your variables.

[Delerna]

also, dont know if you moved it for the example but the Then statement should be on the same line as the if and the condition

[Rabbit]

also, dont know if you moved it for the example but the Then statement should be on the same line as the if and the condition

That's probably it, good catch.

[achroiet002]

Hi all,

Thanks for the solution, problem solved!