I'm trying to create a form to pull records that are identified by a last name and first name. The user will enter a last name for the query and then see a combo box with the first names that match the last name entered. When the user selects a first name from the combo box, the matching record will populate.
I've tried setting up the form with the last name query to run on load, the last name query as the record source for the form with a SELECT query in the row source for the first name combo box, and the last name and first name in one combo box. Nothing has successfully loaded the combo box and the record.
