How to create report similar to order form?

[DariusD]

Hopefully somebody can get back to me today. I am trying to create a form similar to an order form. This is for my sons project and needs to be done by Monday.

[pbaldy]

What's the question/problem? Typically you'd use a form/subform or report/subreport.

[DariusD]

What's the question/problem? Typically you'd use a form/subform or report/subreport.

Ok basically I want to be able to create a report that looks like my form attached earlier, but instead what happens is it shows a list of all the order. I want one order to show in a report. as if it is a receipt order for the customer. I dont want a listing of every order. I would like to somehow select the order and then generate a report for that order and only that order.

However I created a query... maybe it would work better from a query, but I still need it to just show one order, based on the order I select.
For instance if I want to show the order for customer Bob Jones order 15.. I want to get a report for just him. an dthen it should give me a sub total of each product, and then a total at the bottom...I attached a copy of my database....thank you...the query is called Order query


ATTACH]10687[/ATTACH]stemproject.zip

[pbaldy]

Unless I'm blind, there is no such query in the db. This might help display a single order:

BaldyWeb wherecondition

Typically the items in the subform/subreport would be kept in sync with the main form/report with master/child links.

[roaftech]

I hope this is not too late but I do have something which (if I understand correctly) should help.


In my case I have a form which has details of the recipient and the transaction data (ref, date, etc) and a subform which includes details of the items received. The key is in the properties set up for each form:

Main form:
Default view - Single form
Allow Form View - Yes
Allow Datasheet View - No

Sub form:
Default view - Continuous Forms
Allow Form View - Yes
Allow Datasheet View - Yes

You need to link the two forms using a master-child relationship.

HTH