adding to and displaying results in a text box

[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.

 

[Van T. Dinh]

Set the ControlSource of your TextBox to:

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

where YourQuery returns the rows that you want to select.