get a text field to count records of a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that imports a selected CSV file into a table in the database
I want to have a field on the form showing how many records are in the table AFTER the import..

Currently..
I am doing this with a list box that has a record source that counts the records of the table. But while this works to "display" the result, since it's a list box, I cannot use the value of that field without clicking on it.

So, can I set the value of a regular text box to count the records of a table?
 
McLean said:
I have a form that imports a selected CSV file into a table in the database.
I want to have a field on the form showing how many records are in the table AFTER the import...

Currently...
I am doing this with a list box that has a record source that counts the records of the table. But while this works to "display" the result, since it's a list box, I cannot use the value of that field without clicking on it.

So, can I set the value of a regular text box to count the records of a table?
Click to expand...


How about using =DCount("*", "table")
 
Back
Top