Hi

I am trying this code on my form button

    amt = DLookup("[Inc_Amount]", "Incentives", Me.Total_Run.Value & "Between [Start_KM] and [End_KM] And [Inc_Catageory]='" & Me.Route.Value & "'")


Where Amt I defined as Dim Amt as Double
Incentives is my Table containing following fields
Inc_Amount    (Type Number)
Start_Km        (Type Number)
End_Km         (Type Number)
Inc_Catageory (Type Short Text)


On form I have two  variables Total_Run and unbound variable Route as Combo
when I select route and enter value of total_run it gives me following error

Error 94. Can you please guide me and correct this code

Or is there any other way to do the same via select statement