DLookup Help

[Robby19]

I want to lookup a "Grade" (unique number) based off of a text box input on a form. If the Rank in the form is equal to the Rank in the table, then show the corresponding Grade from said table.

=DLookUp([tblGrades]![Grade],[tblGrades],[tblGrades]![Rank]=[txtRank])

The above doesn't work. Need help please.

 

[stumac]

The arguments for Dlookup should be passed as strings - try:

=DLookUp("Grade","tblGrades","Rank = '" [txtRank] & "'")

 

[xenou]

or possibly:
=DLookUp([tblGrades]![Grade],"tblGrades","Rank=" & "'" & [txtRank] & "'")

or if Rank is numeric then:
=DLookUp([tblGrades]![Grade],"tblGrades","Rank= " & [txtRank])

 

[Robby19]

Thank you for the help. Had to modify it slightly, but this seems to work;

=DLookUp("Grade","tblGrades","Rank =" & "'" & [txtRank] & "'")

 

[stumac]

Just noticed I missed a & out

=DLookUp("Grade","tblGrades","Rank = '"[COLOR=#FF0000] &[/COLOR] [txtRank] & "'")

Glad you got it to work!

 

[xenou]

for some reason I was thinking this was a form field: [tblGrades]![Grade]
Anyway glad it works.