i dont understand why i'm getting errors on code below in Access

Anybody Here 0 Reputation points
2024-08-25T13:42:51.4833333+00:00

ID = Nz(DLookup("UserID", UserT", "UserN=""" & UserN & """"), 0)

Microsoft 365 and Office Access Development
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ken Sheridan 2,851 Reputation points
    2024-08-25T15:00:35.1633333+00:00

    You are missing an opening quotes character before the table name UserT.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.