I am working on Access 303 #4 Subroutines.
After working on your assignments in class and I have an understanding of the lessons I take what I've learned and put it into a project that I am working on. Question, when I designed the Bill To and Ship To Address my state is in a combo box. I can't get the Bill To State to get the data from the customer table. It will bring up the Ship To Address data. I can manually enter the state into the order form. It just won't do it automatically. What am I doing wrong?

---

Reply from Alex Hedley:

Is State stored as a Number or Text?
Is the Combo that has all the States got an ID and a Name, so multiple columns.
Are you copying the Bill To State value to the Ship To State value?