current subform

[ppoole16]

How do I get a report to display only the current form and subform displayed on the screen?

 

[WayneRyan]

ppoole,

Base your report on a query. The query can join the two tables
based on your key field, for example CustomerNumber. In the query's
Criteria for the CustomerNumber put:

=Forms![YourMainForm]![CustomerNumber]

which is the name of the control on your form.

Then make a command button with an OnClick event of:

DoCmd.OpenReport "YourReport", acPreview

Wayne