Dlookup Help Needed Please

[graviz]

When I run the command button I get the "You canceled the previous operation" error. Keep in mind I'm not pulling anything from the form. It's only ref fields in my table.


Table: "TBL_Kick"
Fields: "Num" & "KU" (Both Text)

Private Sub Command4_Click()
Dim rr As String
rr = DLookup("[KU]", "TBL_Kick", "[Num]= KickIt")
MsgBox rr
End Sub

Any ideas?

 

[pbaldy]

This should help

http://access.mvps.org/access/general/gen0018.htm

 

[graviz]

This should help

http://access.mvps.org/access/general/gen0018.htm

Thanks! No idea how I missed that.

 

[pbaldy]

No problem!