Transcribing From Continuous Form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Transcribing From Continuous Form

Richard Lanoue

3 months ago

Is it possible to have a continuous form of customer names and have it all transcribed to a single text field on the parent form.

Example: Customer1 in sub-record 1 Customer 2 in sub-record 2. then on parent form it is concatenated to a single text field as =Customer1 & ", " & Customer2 ...
If so how?

	Kevin Robertson @Reply 3 months ago
Yes. Totally possible. See screenshot below for an example.

	Kevin Robertson @Reply 3 months ago

Kevin Robertson @Reply

3 months ago

I played about with this for a little while and this is much better code.

Details

Public Sub ListCustomers()



    Dim frmSub As Form, rs As Recordset

    Dim custName As String, S As String



    Set frmSub = forms!CustomerParentF!CustomerSubF.Form

    Set rs = frmSub.RecordsetClone



    If Not (rs.BOF And rs.EOF) Then

        rs.MoveFirst

        While Not rs.EOF

            custName = Nz(rs!FirstName, "") & " " & Nz(rs!LastName, "")

            custName = Trim(custName)



            If Len(custName) > 0 Then

                If Len(S) > 0 Then S = S & ", "

                S = S & custName

            End If



            rs.MoveNext

        Wend

    End If



    txtCustomers = S



    rs.Close

    Set rs = Nothing

    Set frmSub = Nothing



End Sub

RecordsetClone
String Functions
Trim Function

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View