It seems to be working for the most part. A few issues:
The Combo box control is pulling up repeats. (data is alread in the database).
For example in my CmbCity combo box for city it pulls:
- City A
-
City A
-
City B
-
City B
-
City B
I only want each city to show up once in the selection.
Originally I had this set up with several lookups. This cause a great deal of extra relationships. The structure was not managable.
*FIXED* I fixed the repetitive entries by adding this as my Row Source:
- SELECT distinct [field] FROM [Table] ORDER BY [field]
However, I cannot select an entry to place in the combo box. It is just a dead click. Hmmm.
*Fixed* The ControlSource was incorrect.