Re: Adding multiple subform fields to a mail item in Access

I should have included an example of the result. Let's say there are 3
records in the Part Count Subform: What's happening now is the subject
line is populating as:

3 x Part Name A - 3 x Part Name A - 3 x Part Name A

Where it should be:

3 x Part Name A - 2 x Part Name B - 5 x Part Name C

So it seems to be moving through the records the correct number of
times but is only populating the first record that number of times. I
should also point out that Part Count subform is based on a query and
not a table. Does that matter?

Thanks

.

Relevant Pages

  • Re: populate subform
    ... When you say SubForm are you referring to an Access type of form? ... > populating unbound forms, but not a lot. ... > I'd love for my programmer to finish this, but he moved to another firm, ... >> Jan Hyde ...
    (microsoft.public.vb.database.ado)
  • Re: automatically populating subform
    ... respondent information like grade, class and age. ... tblStudentSurveyAnswers Subform is the name of my subform, ... Dim rsClone As Recordset ... To clarify my last post - The subform is not populating until I ...
    (comp.databases.ms-access)
  • Re: Copy and paste automatically in Access Form
    ... the table that's populating the subform. ... Doug Steele, Microsoft Access MVP ... It seems like there should be an easy way to accomplish ...
    (microsoft.public.access.forms)
  • Re: automatically populating subform
    ... respondent information like grade, class and age. ... tblStudentSurveyAnswers Subform is the name of my subform, ... Dim rsClone As Recordset ... To clarify my last post - The subform is not populating until I ...
    (comp.databases.ms-access)
  • Re: Form not populating correctly
    ... I have checked that ...yet the form is not populating ... >the subform, display properties, select tab Data, and in ... >the subform should be linked on. ... want to populate the detail records. ...
    (microsoft.public.access.formscoding)
Loading