MS Access database support - Reports with Continuous Forms

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Reports with Continuous Forms

MSK

2006-04-05, 11:36 am

Hi,

I would like to generate a report for a specific record from a
continuous form

Env: MS Access 2003 , ADP project , ADO , SQL server 2000

Workflow:

1. Constructed a recordset using ADO +SQL Server Stored procedures +
Command object
2. I have a continous form with lot of values including one primary key
using the recordset
3. Assigned the recordset into a report

While generating report from the continuous form..report is showing all
the records..
I want to see the specific records ...user may select 15th record and
he wants to generate a report for that ...

I tried the following ..but no success

1. Filltered in the recordset before and after assinged into the
reports
2. Filltered in the report
3. added where caluse while showing the report (docmd.openreport....)

Many thanks

- MSK

Sponsored Links