adding to and displaying results in a text box

  • Thread starter Thread starter Russell
  • Start date Start date
R

Russell

I know how to run a query to get the total row count of a
database. What I need to know is how I would code this
total to add 1 to it and then display that total in a
text box on a form. Thanks for any and all help.
 
Set the ControlSource of your TextBox to:

= DCount("*", "YourQuery") + 1

where YourQuery returns the rows that you want to select.
 
Back
Top