samle tekst fra poster i løbende underformular til andet tekstfelt

This is a simple example which you can use
There is a field in the detaill named me.BranchNr
and I have place an unbound text field on the report footer named me.textTotal

Dim Total As String

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)


    Total = Total & Me.BranchNr
   
   
End Sub

Private Sub PageFooter_Print(Cancel As Integer, PrintCount As Integer)
Me.textTotal = Total
End Sub

hmmm, fint nok, men jeg kan sgu\' ikke rigtigt se, hvordan jeg skal bruge den?!?

Jeg skal ikke printe noget ud, det hele foregår på skærmen.....

Sorry! For some reason I thought you were using a report. Will get back shortly :)

Doing this on a form isnt as easy as on a report!

Are you using Access 2000 (ADO) or 97 (DAO) Or ?

This is an example in Access 97 (DAO).
You have a field in the named txtTotal and the field you want to Concat. is BranchNr

Private Sub Form_Current()
Dim rs As Recordset

    Set rs = Me.RecordsetClone
    rs.MoveFirst
   
    Me.txtTotal = \"\"
    Do Until rs.EOF
   
        Me.txtTotal = Me.txtTotal & rs!BranchNr
       
        rs.MoveNext
    Loop
   
    Set rs = Nothing
   
End Sub

Hey! how about closing this question.