Compile Error Syntax Error

[Mohamed]

Hi
Wonder if anyone can help
I get an syntax error when compiling the code below.
Any help will be much apprediated.
Thanks



Private Sub Command105_Click()
If IsNull(Me!Encryption_Password) Then
Me!Encryption Password = DMin("[Encryption_Password]", "QueryEncryption", "[Encryption_ID]=" & Me!Encryption_Password)
Debug.Print DMin("[Encryption Password]", "QueryEncryption")

Debug.Print LaptopID, Me!Encryption_Password

End If
End Sub

[pbaldy]

On what line? For starters, it seems odd to test that a field is null and then turn around and try to use the null field as a criteria. This line should be:

Debug.Print LaptopID & ", " & Me!Encryption_Password

[Mohamed]

Thank you for your reply and help

The line on which the error is on is

Me!Encryption Password = DMin("[Encrpytion_Password]", "QueryEncryption", "[Encrpytion_ID]=" & Me!Encrpytion_Password)

[pbaldy]

The inadvisable space in the name would require it to be bracketed.