ADP parameter dialog

C

Chris Malan

I have searhced everywhere for an answer to this one.

An Access 2003 ADP project is the front-end for a SQL Server 2003 database.
Many reports are based on procedures taking parameters defined in SQL Server,
but visible in the ADP project. They work very well.

There is no problem entering dates in the parameter dialogs that pop up.
The problem is when the parameter is, say a customerID. How do I populate
the parameter dialog that pops up with the sql query "select distinct custID,
custName from tblCustomers"? This should then be a drop-down list.

Second question: if no value is selected, all customers should be returned.
How do I do this?

I have an example in an MDB project that calls a user defined form that acts
as a parameter dialog. This does not work in the ADP project.

Can this even be done in an ADP?

Thanks,
 

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

Similar Threads

Task Information Dialog Box not making duration changes to task 0
Set-MsolUserLicense cmdlet gives error 'A parameter cannot be found that matches parameter name TenantId' 0
ADP & Subreports 1
Pass Parameter Query from SQL Function to an ADP Report 0
Display weeks from a Milestone 0
ADP Developed in Access 2007 opened in Access 2003? 11
ADP PARAMETERS 1
Insert Multiple Fields without Dialog closing between each... 0

Top