afterupdate autofill combo box, selecting if there is only one
I have two combo boxes that are used to pull up records on a form. The first combo is the Last Name and second is the first name of people in the table. I have the first combo box narrow the selection of the second combo box but I would like to add an if statement. If there is only one selection(ie. Smith in first combo and Joe in the second) then I would like it to automatically put Joe in the second combo if you select Smith in the first combo.