Display Record Count in form used to import scheduled files

[Bcanfield83]

Hello,


I have a form in my database that is used to import a series of scheduled reports that are saved to a network drive on the 1st of the month. There's 6 files in total, each of which are .csv files that use a common import specification.
Each file gets imported into a different table in the database. I have a reference table that lists the File Name, Import Table Name, and Last Imported Date. This information displays in a List Box on that form. We then select the file from the List Box and click a button which calls the sub-procedure to import the file into that table.
I'd like to update this to also display the record count for each file/table. Thus, after importing the file, the List Box would display the # of records that imported in another column.
Is there a way to accomplish this without adding a new "Record Count" field to the aforementioned reference table (and then simply updating the List Box to display that additional column). I'm already familiar with how to use the DAO Recordset object to determine the # of records (count) in a table.

So I guess what I'm asking is if there's a way to programatically (through VBA) display information in a List Box, or would it need to be incorporated into the existing Row Source (in this case, the Row Source type is a table) in order to display that additional column/field in the List Box?

Thanks.

[Bulzie]

Thinking cleanest way as you seemed to mention is to add the field to the table and include in the list box, then after an import runs, do the count code to populate that field for that table(import) record, then requery the list box to now display that data. Might be a way to update variables in the list box but you have a few when dealing with fields, sizes, number of columns, etc.

[Gicu]

If your 6 target tables have a DateImported (using a default value of Date() or Now() so it autopopulates on import) date field you can simply add a dCount with today's date as the criteria) to the row source of the listbox.

Cheers,

[Bcanfield83]

Thank you both!