Normally when I want to print the record data on the screen (one record) I create the query and use the criteria property in the unique field. ([forms]![formname].[fieldname]. A command button referencing a macro to run the query and print the record in the report always works until now. The difference with my current project is that I am using the record displayed in a main form and a sub form.
For example: Main form is its own table and contains client data (name, address, etc). The sub form is its own table and contains estimate data (Estimate date, Estimate #, Description of work, etc). For each client there will be many estimates. Using the above method I can only get the current client and the first record of the estimate. Whats the trick to this?
For example: Main form is its own table and contains client data (name, address, etc). The sub form is its own table and contains estimate data (Estimate date, Estimate #, Description of work, etc). For each client there will be many estimates. Using the above method I can only get the current client and the first record of the estimate. Whats the trick to this?