[RESOLVED]New problem - error 2001

Okay, i have this code

VB Code:

Dim intPayband As Integer
Me![current payband].SetFocus
intPayband = Val(Me![current payband].Text)
Me![Label14].Caption = DLookup("[Salary]", "AcademicPayband", "[Payband] = intPayband")

And its giving me an error 2001 - This action canceled the previous

Or something along those lines.

if i replace "intPayband" with a value IE) 8
then it works fine, but if I try to pull data from anything it cancels it..

So i tried putting the value into a variable, but still no luck..



*edit*

nevermind, solved it