I have created a Demands database, which includes a text box called Suffix which is a 7 digit number. I have created a table that includes contains items that have been superceded. I require code that will compare a number in the Suffix form field with the Field "Old Suffix" in the "Superceded" table. I require it to show a text box, then if possible inputs the New Suffix and Part No automatically.