I am trying to use a DLookup to fill in a text box"
MTMiles.Value = DLookup("[DHMiles]", "taRate", "[ShipID] = Forms![sfLoadPlanning]![CurrentLocID]" And "[RecID] = Forms![sfLoadPlanning]![Shipper]"
When it is executed I get a 'Type Mismatch!' Error.
What am I missing.
Thanks in advance,
ancb
MTMiles.Value = DLookup("[DHMiles]", "taRate", "[ShipID] = Forms![sfLoadPlanning]![CurrentLocID]" And "[RecID] = Forms![sfLoadPlanning]![Shipper]"
When it is executed I get a 'Type Mismatch!' Error.
What am I missing.
Thanks in advance,
ancb