Hi,
I am trying to create an AfterUpdate code for a text box. Basicly on the form the user selects a number from the combo box. They then type in the name of a person in a text box. What i want Access to do is search a database for records of people who have the number (selected in the combobox) with their name. If they do, i want the form to set the background of the textbox to green and display a label underneath. And if it dosen't then it sets the background of the textbox to red and also displays a label underneath.