I created a customer form and added a list box to show the customer representatives associated with that customer. Works great! I then added a list box to show the ship to addresses associated with the same customer. It doesn't work! The Ship to addresses show up in different customers, sometimes the one with a customer ID 1 digit higher, sometimes 2 digits higher and occasionally anywhere in the ship to table. The SELECT statements are located in the list box properties and are identical in their format. What am I missing here?
Thanks,
Tom

---

Reply from Alex Hedley:

Make the Queries as their own object with a Form Criteria.
You can then set the Listbox source to these.
Open the Form and run the Query from the Navigation Pane to see if it's working as expected.
Check you are using the correct criteria and it has the right ID.