I'm looking how to look for a duplicate in a form and display a msgbox if it's true and go to that Transaction Number or enter new ticket if false. I have a table named InHouseAccount a field named InHouseAccountID set to autonumber and a field named TransactionNumber Data type set to number and a form named EnterNewTicket with a text box named TransactionNumber. Would someone help me with the code. Thanks for any help