Re: Showing total amount of entries on a form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You could place a text field on your form and in the control source put

=count(*)

or

=count([FieldName]) - A field name that shows up on every record, like
the primary key.


weircolin@xxxxxxxxxxxxxx wrote:
Hi there

On the bottom of forms you can select to have the "counter" showing how
many entries are on a table. Is there any way of getting this amount
listed in a text box instead?

Thanks

Colin

.

Relevant Pages

  • Re: Copy and Paste subform records
    ... > primary key for the new record. ... > Dim recSet As DAO.Recordset ... > ' Copy selected subform records for new main ... > not "MovePrevious," if the user selects the records from the bottom to the ...
    (microsoft.public.access.formscoding)
  • How to get field from lookup?
    ... Dlookup expressions in the control source property. ... If the primary key is in table1, ...
    (microsoft.public.access.formscoding)
  • Re: Changing unbound combo boxes to bound
    ... Category ID (primary key) -autonumber ... Component ID - autonumber ... I have created a form that has an unbound combo box that lists all ... name the control source (I also tried to make product id the control source ...
    (microsoft.public.access.modulesdaovba)
  • How to get field from lookup?
    ... >Dlookup expressions in the control source property. ... If the primary key is in table1, ...
    (microsoft.public.access.formscoding)
  • Help with form/subform problem
    ... Each year they have to complete a registration form ... So I have a table tblIDCards with Primary key CardID, ... IName2 whose control source should reference IName with this as the control ... When I try to enter data in the subform frmidcards I get an error message ...
    (microsoft.public.access.forms)