Hi guys,
Me again,
Trying to Dlookup a numeric value with 2 text criteria
Me.BillingRate = DLookup("Rate", "tblBillingRates", "Category = '" & Me.Category & "'" And "Position = '" & Me.Position & "'")
With above I get type Mismatch Error 13 and for love or god, can't understand why.... tblbillingrates snapshot is below, BillingRate is a field on my form alongside category and position
Any ideas?
Me again,
Trying to Dlookup a numeric value with 2 text criteria
Me.BillingRate = DLookup("Rate", "tblBillingRates", "Category = '" & Me.Category & "'" And "Position = '" & Me.Position & "'")
With above I get type Mismatch Error 13 and for love or god, can't understand why.... tblbillingrates snapshot is below, BillingRate is a field on my form alongside category and position
Any ideas?