Share via

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)

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
876 questions
0 comments

1 answer

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

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

    0 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.