returning Access data to Excel
 

I need to have users select a customer ID from a drop down in an Excel form,
then return data from a MS Access database into an an Excel worksheet
filtering for the Customer ID. Any ideas on how to do this?

returning Access data to Excel
 

Hi Luke

See
http://www.rondebruin.nl/accessexcel.htm

In the download I have a file that use data validation dropdowns to pick your ID
Maybe you can use it

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Luke Bailey" wrote in message ...
I need to have users select a customer ID from a drop down in an Excel form,
then return data from a MS Access database into an an Excel worksheet
filtering for the Customer ID. Any ideas on how to do this?

returning Access data to Excel
 

Thank you Ron! Excellent example of what I am trying to do.

Luke

"Ron de Bruin" wrote:

Hi Luke

See
http://www.rondebruin.nl/accessexcel.htm

In the download I have a file that use data validation dropdowns to pick your ID
Maybe you can use it

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Luke Bailey" wrote in message ...
I need to have users select a customer ID from a drop down in an Excel form,
then return data from a MS Access database into an an Excel worksheet
filtering for the Customer ID. Any ideas on how to do this?