I am hoping that someone can help me with this.

I have two forms:

Enquiries

Look Up Customer Name (Drop down)

Look Up Contact

Customers

Name 

Contact (Subform): Name, Telephone, Email

I am trying to make it so that when a customer is selected from the drop down, the Look Up Contact gives a drop down of all contacts for this customer.

Any help much appreciated.

Thanks,