Solved dlookup with two criteria both on form (1 Viewer)

[murray83]

evening people

i have searched on here and google and tried some of them out but to no avail

I'm trying to lookup AskKevImage which is text based on the QuestionNo and QRoundNo as shown below but it isn't working a slight hand greatly appreciated

=DLookUp("AskKevImage","tblQuestions","QuestionNo = [txtAskKevQuestionNoTrim] " AND "QRoundNo = Forms!frmQuestions![txtQuizNo]")

 

[theDBguy]

Hi. If this is on the same form as the value you're using for your DLookup() criteria, then try it this way:

=DLookUp("AskKevImage","tblQuestions","QuestionNo = " & [txtAskKevQuestionNoTrim] & " AND QRoundNo = " & [txtQuizNo])

PS. The above assumes those fields are numeric. If they're text, you'll have to use single quote delimiters.

 

[murray83]

I do love you

well my database now does, cheers and yes it was numeric

 

[theDBguy]

I do love you

well my database now does, cheers and yes it was numeric

Hi. Glad to hear you got it to work. Good luck with your project.