Are arrays of control objects possible? (1 Viewer)

[gellerche]

I am doing an application where I want to display several rows of related data (Invoice ID, amount due, etc.) and allow the user to change data (which excludes reports). Right now I have to explicitly name each label and text box (eg. lblInvoiceID1, lblInvoiceID2, etc.). Is there a way to use an array for these labels and text boxes to streamline my code?

Thank you,

Steve Geller

 

[jimbrooking]

Steve,

You can set the form's Default View to Continuous Forms, and that will show all the records in the recordsource (or as many as will fit on the form). You can show a vertical scroll bar to "get to the bottom of things".

If you want to tie the recordsource to something like a customer number (e.g., all invoices for this customer) you could have a subform that displays the invoices, with the customer number in the invoice subform tied to the customer number on the main form.

HTH,
Jim