Am now getting a list in the combobox but instead of editing inspection I selected a new inspection is created. Further investigation reveals that frmInspection opens to a new record. Selecting an inspection from the drop list does not retrieve/goto selected inspection. I set the InspectionID textbox on frmInspection to Visible Yes to verify this. I notice now that frmInspection Data Entry property is set to Yes. This forces the form to open only to a new Record. Cannot view existing records.
My code works. Then Private Sub Form_AfterInsert() executes. I have never used this event. When I change the Data Entry property to No this event errors.