Create Subform record along with New record

BJF

Registered User.
Local time
Yesterday, 19:51
Joined
Feb 19, 2010
Messages
137
Hello,

I'm having a problem with my report that i print based on my form.

Please help.

I have a form with a subform.

Based on the info entered into the form i designed a report to print out the info.

The problem is that if I do not enter any info into the subform portion of the form, the report displays no data.

I have to manually click into the subform and make sure a record is created; then my report works.

is there a way in code to create the subform record along with a new record in main form, or is there code to put in report that will allow the main form data to display even if there is no subform data?
 
What data is your report supposed to show, main form or subform or both?
If both or main form, then you need to set your join line between the tables on you relationship to be all records from the parent table and only matching records in the child table.
If subform data, why would you want something to print that does not exist?
It sounds to me like you have the join line set to show only matching data which will prevent data from the parent table from being returned if there is no matching data in the child table. Don't add bogus data to the child table to fix the problem.
 

Users who are viewing this thread

Back
Top Bottom