Help With DLookup With Multiple Criterial

[CharlesWhiteman]

Hi all, I'm getting a type mismatch error on the following DLookup syntax.

strMonthlyTransferLimit = DLookup("Value", "radreply", "UserName =" & Me.txtUserName And "[Attribute] =" & "Monthly-Transfer-Limit")

Any ideas?

Thanks

 

[MStef]

Try this!
StrMonthlyTransferLimit = DLookup("[Value]","radreply","[UserName]=""" &
[Forms]![FormName]![txtUserName] & """" & "And [Attribute]=" &
[Forms]![FormName]![Monthly-Transfer-Limit])

I think the Attribute field is a numeric.