I haven't used Dlookup before and am using the syntax bellow which I found on line but just get Name?? in my unbound text box. Is there something wrong with my syntax? Ive tried everything I can think of. My fields are both text fields. Help is much appreciated.
=DLookUp("Our Sales Price","tbl_Price","[TypeofTicket]= " & [Type of Ticket] & " And [AttractionID]= '" & [SKU] & "'")