How do I get the VBA code for my combo box to repeat for the next record in a form?

[TPezz]

I am new to Access and I'm using a combo box to append fields in a report. The VBA code (see below) that I have written works for the first record, but I have to manually go to the next record and select the value from the combo box again to append that record. How do I get this to automatically go to the next record and repeat the process based on my initial selection?

Private Sub cboInvoiceNumber_Change()
    
        Me.txtInitialInvoiceDate.Value = Me.cboInvoiceNumber.Column(2)
        Me.txtInitialInvoiceNumber.Value = Me.cboInvoiceNumber.Column(1)

End Sub

[Seth Schrock]

You could create a loop to go through all your records in your form.

Me.Recordset.MoveFirst

Do While Not Me.Recordset.EOF
    Me.txtInitialInvoiceDate.Value = Me.cboInvoiceNumber.Column(2)
    Me.txtInitialInvoiceNumber.Value = Me.cboInvoiceNumber.Column(1)

    Me.Recordset.MoveNext
Loop

[TPezz]

Do I need to add something to end the loop? I tried this and it seems to run in a continuous loop.

[Seth Schrock]

What ends the loop is the

Do While Not Me.Recordset.EOF

It will only loop to the end of the recordset (EOF stands for End Of File). Make sure that you have the

Me.Recordset.MoveNext

in there, other wise it will just sit on the one record and it will loop endlessly.

[TPezz]

Do I need anything before the Me.Recordset.Mo veFirst and/or after the Loop

[Seth Schrock]

Not for anything that you have specified in your question. Are the correct values getting appended, or are they all the same values?

[TPezz]

All set, thank you for your help with this!