DLookup multiple criteria

[thescottsman]

Hi all

I have this code

Me.type01.Value = DLookup("Type", "tblDesign", "[Line]='" & Me.Line01.Value & " AND Contract='" & Me.Contract.Value & "'")

contract.value is updated when a button is clicked that has a macro in it

Can anyone please tell me where this code is going wrongm and also where I should but it to achieve the best results, such as afterupdate()

thanks in advance

 

[plog]

"[Line]='" & Me.Line01.Value & " AND Contract='" & Me.Contract.Value & "'"

I count 3 single quotes. They should come in pairs.