dlookup syntax

[lesliesoup]

I am going crazy trying to find what is wrong with this dlookup statement. I am sure it's a stupid quote somewhere. My eyes are no longer focusing trying to find it . Any help would be greatly appreciated

=DLookup("[Patient_Weight]", "Frailty_Assessment", "[Patient_StudyNum]='" & Me.Patient_StudyNum_
        & " AND [Assessment_Type]= " 'Inital' ")

 

[madefemere]

Hello,
May be like there ?

[FONT=Arial][SIZE=2]
' If Me.Patient_StudyNum is numeric
axe = DLookup("[Patient_Weight]", "Frailty_Assessment", "[Patient_StudyNum]=" & Me.Patient_StudyNum _
        & " AND [Assessment_Type]='Inital' ")
' If Me.Patient_StudyNum is text
axe = DLookup("[Patient_Weight]", "Frailty_Assessment", "[Patient_StudyNum]='" & Me.Patient_StudyNum _
        & "' AND [Assessment_Type]='Inital' ")

[/SIZE][/FONT]

 

[pr2-eugin]

Hello lesliesoup, Welcome to AWF

Try this..

= DLookup("[Patient_Weight]", "Frailty_Assessment", "[Patient_StudyNum]='" & _
          Me.Patient_StudyNum & "' AND [Assessment_Type]= 'Inital'")

 

[lesliesoup]

Thanks, it worked! I had spent hours trying to correct it.