I have a Form that seems to be working correctly except for this one item. I must be missing something.
First combo box selects the CustomerID. 2nd cascading combo box shows contacts based on combo box 1. and populated text boxes show the contact information such as phone numbers and email address. All this works correctly while I stay on that record. Also, the table is updated correctly for the Form.
When I move off of the record to create a New Record and move back to a previous record, combo box 1 still shows what was selected, but combo box 2 and the populated text boxes are blank. I want to move to previous records and see what currently is recorded in the table.
I am a first-timer to this (or any) access forum. I hope I have posted to the correct location, and have explained it adequately.