Combo box synch question

J

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
 
P

Philip Herlihy

joeytino said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top