How can I link 4 sub-forms in one main form

  • Thread starter Thread starter Roger Ottaway
  • Start date Start date
R

Roger Ottaway

I have an AccessXP2002 database with a main report that summarises 4
different aspects of the same dossier. The report consists of 4 sub-forms
with each having their own query to extract data. When I preview the main
report, it asks me "which dossier number" four times, once for each
sub-form. When I try to link the child and master fields, it tells me that I
can't link unbound forms. How can I link this so that I only tell it once
which dossier number to report on ?



Thanks



Roger
 
my guess is that your main report is unbound, and the 4
sub-reports (not sub-forms) are each bound to a parameter
query. you can add a query or select statement to your
main report's record source, with a parameter for the
dossier number. then you can link the sub-reports to the
main report, and change the sub-report queries from
parameter queries to simple select queries.
hth
 
Back
Top