single report

[Nick Druce]

When i have a form in access with all the details filled in, how do i print that as a report And NOT have All the fields in the table be printed on the report as well?

 

[krunalprajapati]

u mean u want to create a report from a table that has NOT all the fields of the table but few of them.
than create a report using report wizard and it will ask u which fields u want in report.

 

[Nick Druce]

I have all the fields i need but i only want to print a report for one customer but when i try to print the report displays evrything in the table. I need a way of asking the user to select a customer and then it will print the reoprt for that customer only.

 

[krunalprajapati]

create a form for asking a customer, i.e. with a combo box having rowsource of cust_id or what ever u want. then create a command button. In wizard select record operation and select the report u want to run in preview.


then open the code of the command button
it shows:
DoCmd.OpenReport "ur report name", acViewPreview

add the where condition for ur cust_id in this code as:
DoCmd.OpenReport "ur report name", acViewPreview, , "cust_id = "& forms![ur form name]![ur cust_id field name on the form]

if the cust_id is of text datatype than add single quotes i.e. " ' " before and after the forms![ur form name]![ur cust_id field name on the form].

 

[Nick Druce]

Single Report

Thanks For that. However I would like to be able to not have to prompt the user to input the data Once the from is filled in . They just Click the button and the information that is currently on the form is printed to the report. Any Ideas would be very helpfull.

 

[Nick Druce]

Single report

I have used my own field names but using [] is a prompt for the user to input somthing. That is what I am tryng to bypass