HI, I have a one to many relationship between 2 tables, the form has been created with the one side as the main and the many side as a continuous subform, I would like to print a record where the main form id is passed and the selected subform record has been selected not a report that repeats the form if that makes sense.
This is what I have at the moment.
DoCmd.OpenReport "rpt_wpsform", acViewPreview, WhereCondition:="[tbl_pqr.pqrid]=" & Me.pqrsub.Form.WeldSpecID
The report opens as it should but no data is being passed. any help would be appreciated, it is also difficult to give you a slice of the database, sorry.