Solved Syntax Error

[hucheunghugo]

    If IsNull(DLookup("Staff_ID", "Login", "LoginID = '"&Me.ID&"' and Password = '"&Me.PW&"'")) Then

    End If

I find a login form example video on the Internet and i change the name of text box and field name
But it shows that there are syntax error.....

 

[GinaWhipp]

Your Form name has spaces, change to...

DoCmd.OpenForm "[Movie Info 1]"

Hmm, is Me.ID a number?

 

[cheekybuddha]

    If IsNull(DLookup("Staff_ID", "Login", "LoginID = '" & Me.ID & " AND Password = '" & Me.PW & "'")) Then

    End If

 

[hucheunghugo]

Your Form name has spaces, change to...

DoCmd.OpenForm "[Movie Info 1]"

Hmm, is Me.ID a number?

No Both of the ID and PW are text

 

[cheekybuddha]

                                                             Error here
                                                                |
                                                                V
    If IsNull(DLookup("Staff_ID", "Login", "LoginID = '"&Me.ID&"' and Password = '"&Me.PW&"'")) Then

    End If

 

[hucheunghugo]

    If IsNull(DLookup("Staff_ID", "Login", "LoginID = '" & Me.ID & " AND Password = '" & Me.PW & "'")) Then

    End If

When I use this code, it shows that missing operator

 

[cheekybuddha]

Oops! Ignore my posts! My mistake

 

[hucheunghugo]

Thanks for the help btw

 

[cheekybuddha]

You have a control called 'ID'?

The field in the table is 'Staff_ID'?

If so, then your original code (in Post #1) looks OK. Perhaps add the spaces between the '&', but the VBA editor should do that for you anyway.

 

[hucheunghugo]

When I use this code, it shows that missing operator

It suddenly fixed when I try to add one more quotation mark
Thanks a lot