Hi,

I am using an adp as a SQL Server interface and wondered if the following was possible.

Can I run a report in the adp (using a sql view) and have a combo box parameter appear on running the report, then select a value from the combo box and return the report for that selected value??

Hope that makes sense eg.

Open Report
Combo Box appears with populated list
Select value from list
Report runs, filtered on the value selected from the combo box

Thanks guys
Sorry if I'm a bit confusing, its my first post here :)

I would throw in an intermediate step of having a search form before the report opens. The combo box would be on the search form.
From there it's a simple matter to use the selection in the combo box as the parameter and then open the report.

Thanks Statsman

I also found this to be useful, though a little long winded.

http://www.fontstuff.com/access/acctut08.htm