Report

[Deepa]

Hi Folks,

How do i select a few records from MS Access(letz say a form) & populate the same onto a MS Access Report. I dont want to use a query.
The user has to choose the records (say thro a checkboxes) & generate the report on click of the button.

Please respond ASAP

 

[dgm]

If your talking about a couple of fields from a single record then it would be easy enough to reference the fields from the report:
forms!frmName!txtFieldName

Otherwise the best way would be to use a query...
Any reason why u don't want to use a query?

 

[Deepa]

Hey thanks for replying ASAP.

Well want I require is a User Interface where in the user chooses a list of milestones ( i cud use the listbox ), then on click of a button I want a report.

The report should have the chosen milestones. Now each milestone has activities & each activity has tasks. The activities & the tasks should also be shown in the report.

I have created a query where in by passing the milestone id i get the activities & the tasks. Now i want this query to run for each of the selected milestone.

Well, sorry abut the wrong lead abut not using queries.


Regards,
Deepa

 

[Deepa]

Yup...it has the solution partly...What i am looking for is a MS Access Report so that i can use formatting..

I donot have Microsoft VB help file installed on my system. Is there a link from which I can download it?

Regards,
Deepa

 

[Deepa]

hey thanks a lot