Function to return number of records in table

[Challseus]

Hi all: Having some problems again that just aren't making sense to me. I'm looking for a function that will return the number of records in a table or form. I type in the name of the table/form followed by ".", but I don't see and numRecs function or anything like the sort.

The reason I need this is so when I display a form, I want it to automatically go the last page. Now, maybe there's even function that will do that for me, I don't know, but I know there has to be a function that returns the record count, not sure why I can't find it.

Now that I think about it (sorry for rambling), is there a function that will return the index of the record you are in. That would help out a lot as well. I know it seems like I'm lazy, but I don't have the CD to install help files and I cant seem to find the anwers anywhere else. Any help is much appreciated.

 

[Russell Hauf]

This will take you to the last record

    DoCmd.GoToRecord , , acLast

HTH,

Russell

 

[Challseus]

Sorry, maybe I wasn't specific enough. I apologize. Is there any way to get to a blank record?

Let me break my dilema real quick before I leave work:
The user will be filling out 1 from the has 4 fields (name, add, phone, etc).
If the name they type isn't in a table that I query, then I want to show the form that can enter in new info. That part is working fine. This is basically cosmetic, but I just want the first record shown when they are prompted to fill in new info to be empty. Hoep this helps a little more.

 

[mdmilner]

Yes, same syntax.

DoCmd.GoToRecord , , acNewRec

If you still need to count the number of records in a table, you can open it in a recordset and look at the GetRows property. There's probably another more direct method though.

Mike