I create the combobox and choose the 3rd option (to choose from a list on my form). The form was based on the customerT (patientT in this case). I tried several different ways the last of which was to create a query with the patientT and a FullNameQ i created to combine last names and first names. the combo box searches great either way til i close access and re open. then i get the error in the pic attached. pic of form with error message
I have also tried creating a search form and using the wildcard function in the query but everytime i enter the formula in the criteria, Access changes LIKE to ALIKE. Is it supposed to do that? i watched 3 diff videos to copy how they created a search form. I dont see their formula adding the A when they click off the field or hit enter.