syncronized combo box

[hogan]

I have a database with customers and each customer can have more than one
location/address. I am creating a shipping form and by using synchronized
combo boxes i am able to select the customer and that customer's ship to
addresses appear in the second combo box. This works great when the form is
on its own but when the shipping form is a subform, my Where clause below is
incorrect. I have tried everyway to reference the Customer ID field in my
subform but I have had no luck.

Query: Syncro
Column 0: SHIP TO #
Column 1: CUSTOMER ID (where: forms.shipping form.CUSTOMER ID)

My main form is called IN HOUSE SERVICE WORK ORDERS. Any helps is appreciated.

Thanks

 

[ruralguy via AccessMonster.com]

Here's a link that should be helpful with the proper syntax.
http://www.mvps.org/access/forms/frm0031.htm