Query = qryNetbase
Controls:
Netbase
[TOE Title]
[Equip HB Name]
Query2
Base: DLookUp("[Netbase]","[qrylNetBase]","TOE Title = " & [TOE Title] & " And [Equip HB Name] Like '*TCN'")
I get a syntax error (missing Operator) in query expression 'TOE Title = 1-1 CAV SQDN And [Equip HB Name] Like '*TCN''
I am wanting to compare each records netbase where [Equip HB Name] has the Initials TCN in it. Then if not I can change the Netbase to the correct on for that TOE Title.