I have one table with a number of customer records. One field is a phone number. I would like to input a phone number into a combo box and have it search the form then display all the records that match the phone number in the subform.
For instance, if I type in (111) 111-1111 the subform should supply all the instances that those records occur. I’ve included a sample database but I don’t know how to link the combo box to the table and have the records appear in the subform.
Any help would be appreciated.