display query record count in form

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,

i am trying to display the count of records in a query in
a text box on a form (the query is a check query that
tells me everything is ok in the db). i did do this many
moons ago once but i dont seem to have remembered
correctly what i did and am at a bit of a dead end so any
help would be most appreciated.

Here is what i have set the control source of the text
box to be:

=[checkquery - total records should equal
inventorymovement table].RecordCount

and i get a #NAME error when i open the form.

thanks
Mark
 
I don't follow what you have put in the control source, but look at the
DCount function. It willl return the number of records in a table or query.
 
Back
Top