I got it to work by bringing in the LocationID, CustomerID, and LocationName on the list box through the wizard and this SQL:

SELECT LocationID, LocationName FROM LocationT WHERE CustomerID=Forms!CustomerF!CustomerID ORDER BY LocationName;

At 4:10, the vid shows only LocationID and LocationName on the list box through the wizard. For me, it won't without bringing in the CustomerID with LocationID and LocationName.

Thanks! (Access 2010, btw).

---

Reply from Richard Rost:

That's my mistake. I should have realized that the SQL field list didn't include the CustomerID. You MUST have a field in the field listing if you want to use it in the WHERE condition. Sorry. Good catch.