I wasn't sure what to put in the title but basically this is my problem. I don't know anything about writing code or anything, i've just been using the wizards in Access 2007 for designing my database.
I have a form that has some of the following info from a table:
Parent Company
Address
State
Zip
I made a combo box that has lets me choose the parent company and then autofills the rest of the information. My problem is that it auto fills any "Parent Company" except one.
For example... the choices in the combo box are:
Swedish Medical Center
Children's Health Clinic
Auburn Surgery Center
Bellingham Regional Hospital
If I select Swedish, Auburn or Bellingham, the form fills in all the values it should. When I select Children's Health Clinic, it fills the form with whatever the last value selected in the combo box was.
I looked on my table and all the information/values seem to be fine.
Anyone know why it is only not working for that one value?
Britt