Combo box synch question

[joeytino]

I have a form with 2 combo boxes. The first one allows you to select a
customer which i want to then populate the second combo box to populate with
the dates of all completed orders from this customer. I have the first box
working, and it's based on the Customer field in a query that pulls all
complete transactions from 2 tables: Received and Sent. The Row Source for
the Customer combo box is

SELECT DISTINCT [CompleteQuery].Customer FROM CompleteQuery ORDER BY
[Customer];

I use DISTINCT because each record contains the customer name, so I only
need one instance for the pulldown. The same will hold for the date combo box
as well.

I want the second combo box to pull the date from the query but I can't
figure out where I'm going wrong. Any pointers would help greatly.

Thanks
Joe

 

[Philip Herlihy]

I have a form with 2 combo boxes. The first one allows you to select a
customer which i want to then populate the second combo box to populate with
the dates of all completed orders from this customer. I have the first box
working, and it's based on the Customer field in a query that pulls all
complete transactions from 2 tables: Received and Sent. The Row Source for
the Customer combo box is

SELECT DISTINCT [CompleteQuery].Customer FROM CompleteQuery ORDER BY
[Customer];

I use DISTINCT because each record contains the customer name, so I only
need one instance for the pulldown. The same will hold for the date combo box
as well.

I want the second combo box to pull the date from the query but I can't
figure out where I'm going wrong. Any pointers would help greatly.

Thanks
Joe

This any help?

http://office.microsoft.com/en-gb/access/HA011730581033.aspx?pid=CL100570041033

Phil, London

 

[Philip Herlihy]

I have a form with 2 combo boxes. The first one allows you to select a
customer which i want to then populate the second combo box to populate with
the dates of all completed orders from this customer. I have the first box
working, and it's based on the Customer field in a query that pulls all
complete transactions from 2 tables: Received and Sent. The Row Source for
the Customer combo box is

SELECT DISTINCT [CompleteQuery].Customer FROM CompleteQuery ORDER BY
[Customer];

I use DISTINCT because each record contains the customer name, so I only
need one instance for the pulldown. The same will hold for the date combo box
as well.

I want the second combo box to pull the date from the query but I can't
figure out where I'm going wrong. Any pointers would help greatly.

Thanks
Joe

This any help?

http://office.microsoft.com/en-gb/access/HA011730581033.aspx?pid=CL100570041033

Phil, London