DLookup to populate form

[OMGsh Y did I say Yes]

I have the following DLookup statement:



=DLookUp("[Repair Directory]![TAT]","[Repair Directory]",("[Repair Directory]![PartNumber]=[forms]![QuoteLineItems2]![combo17]" And "[Repair Directory]![RepairDes]=form![QuoteLineItems2]![Combo25]"))

My goal is to have Access observe on the form (QuoteLineItems2) what was input into Combo17 and Combo25, then based on that combination fill in the TAT(from table Repair Directory). I can get it to work as a Select statement with a combo box, but then the user must choose the TAT (there is only one piece of data) and it does not auto-populate.

When I run the DLookup above it inputs the first field of the table (Repair Directory) every time.

Any suggestions?

[weekend00]

if partnumber is a text field and [repair directory] is a text field:
=DLookUp("[Repair Directory]![TAT]","[Repair Directory]","[Repair Directory]![PartNumber]='" & [forms]![QuoteLineItems2]![combo17] & "' And [Repair Directory]![RepairDes]='" & form![QuoteLineItems2]![Combo25] & "'")


if partnumber is a number field and [repair directory] is a text field:
=DLookUp("[Repair Directory]![TAT]","[Repair Directory]","[Repair Directory]![PartNumber]=" & [forms]![QuoteLineItems2]![combo17] & " And [Repair Directory]![RepairDes]='" & form![QuoteLineItems2]![Combo25] & "'")

[OMGsh Y did I say Yes]

Thank you weekend00!

Is there any reading on the web you would suggest to help me understand how the "&" works?