Form To Report......

[ankit]

Hey all,

i have designed a invoice form and am having trouble taking the values on the invoice form to a report. The report will act as an invoice to be printed. On my form there are mutliple fields from 2 tables such as 'invoice master table' which includes details such as invoiceid,invoicedate, customer number,employee number. The second table(used as a subform) that is used in the form is 'invoice details table' which contains details such as productid, retailprice, quantity. I have made other fields on the form to do calculations such as total price, price of each product depending on the quantity. I was wondering how i would design a report that contains these details from the form.

All help would be great have a nice day

 

[MStCyr]

You can save your form as a report by right-clicking on the form

 

[ankit]

re:

Thanks for the reply, i didnt know there was a feature like that, but i am still having problems as i want the report to be individual to each invoice form. I want teh report to act as an invoice for each form. Basically i am going to put a button at the bottom of my invoice form to preview the report. How would i go about doing this? All help would be great

 

[MStCyr]

Your command line would be something like this:

DoCmd.OpenReport "rptDetails", _
WhereCondition:="RecordID=" & Me.RecordID

or you can create a query to print only the current record