What is wrong with this DLookup? 1

[ancb]

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]&quot

When it is executed I get a 'Type Mismatch!' Error.
What am I missing.

Thanks in advance,

ancb

 

[RoyVidar]

Hi!

Try

[tt]DLookup("[DHMiles]", "taRate", "[ShipID] = " & _
Forms![sfLoadPlanning]![CurrentLocID] & " And [RecID] = " & _
Forms![sfLoadPlanning]![Shipper])[/tt]

- if both fields are numeric and the form in question is open

Roy-Vidar

 

[ancb]

Thanks RoyVidar,

The &s did the trick.

Here's a star.