Link to home
Start Free TrialLog in
Avatar of Richard
Richard

asked on

access subform-printing one record

I have one table Clients and this has a relationship to Files.
One client can have many files.

I have a subform Files on the main form Clients


What I would like to do to is to print the contents of one record of the sub form.

I need to make a report, prob based on a query and then have a filter in the report to filter one client AND that particular file
So as to print all the clients details and the details for ONE file.
Ideally select the file record from a double click from the file records.

Assistance please appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Something like this:
Database181.mdb