• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

Another DLookup VBA syntax issue

What is wrong with this?

    Me.txtListingsTakenGoal = Nz(DLookup("[ListingsCount]", "tblMemberGoals", "[TeamMember] = " &  Forms!frmSelectDateRangeAndMembers!txtMemberName & " And [GoalMonth] = " &  Forms!frmSelectDateRangeAndMembers!txtMonth And [GoalYear] = " &  Forms!frmSelectDateRangeAndMembers!txtYear)&", 0)
0
SteveL13
Asked:
SteveL13
  • 2
1 Solution
 
mbizupCommented:
    Me.txtListingsTakenGoal = Nz(DLookup("[ListingsCount]", "tblMemberGoals", "[TeamMember] = " &  Forms!frmSelectDateRangeAndMembers!txtMemberName & " And [GoalMonth] = " &  Forms!frmSelectDateRangeAndMembers!txtMonth & " And [GoalYear] = " &  Forms!frmSelectDateRangeAndMembers!txtYear), 0) 

Open in new window

0
 
mbizupCommented:
And like your other question, if TeamMember is text, use quotes as delimiters.  The above assumes a numeric ID:

    Me.txtListingsTakenGoal = Nz(DLookup("[ListingsCount]", "tblMemberGoals", "[TeamMember] = '" &  Forms!frmSelectDateRangeAndMembers!txtMemberName & "' And [GoalMonth] = " &  Forms!frmSelectDateRangeAndMembers!txtMonth & " And [GoalYear] = " &  Forms!frmSelectDateRangeAndMembers!txtYear), 0) 

Open in new window

0
 
SteveL13Author Commented:
Is numeric.  But now I have to add yet another criteria.  Please watch for another topic question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now