T
tina
you've listed field LocaleID as data type numeric, but in
the DLookUp function you've used text delimiters around
the value. try this instead
Me.Fee1 = DLookup("[Fee]", "tblCostByLocale", " [CPTID]
= " & Me![cboCPT1] &
" And [LocaleID] = " & Me.txtLocaleID)
the DLookUp function you've used text delimiters around
the value. try this instead
Me.Fee1 = DLookup("[Fee]", "tblCostByLocale", " [CPTID]
= " & Me![cboCPT1] &
" And [LocaleID] = " & Me.txtLocaleID)