Records question

R

Rpettis31

I have the following code in a new database to list records on form current.
How do I use this code when there are no records as this is a new database.
Me.Dynaset.MoveLast
Me.txtRecordTotal = Me.Dynaset.RecordCount
 
J

Jeff Boyce

Consider using the Nz() function to return a 0.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error on move.last 1
Copy previous record into form field 0
Merging from an Excel file with graphics 1
M.S. Word 365 1
Adding data to MS Access from csv file 0
How do I clear a form? 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Is this possible? 0

Top