How many records? [Resolved]

[Bazzlad]

I need a bit of code...
I could do with a record count. To show how many records are being displayed...
the figure being outputted to a textbox....
this figure will change depending on what filters I put on the page....
so if I only show records which have a boolean value of -1 for a check box I need the count to realise it's counting them...
I know it does it automatically at the bottom of the form, but I want to put it in a text box, any ideas?

[WorkHorse]

You can set TextBox text to the value of Me.RecordCount or in Access you can use "=Count(*)".

[Bazzlad]

Cheers mate!

[Bazzlad]

Argghh, nearly people...
recordset.recordcount Shows which record I'm on.... record 1, record 2 etc, I need the TOTAL of records.....?
Or the LAST record...

[Bazzlad]

Done it at bloody last, sloppy code always comes through

Dim stDocName As String
    Dim stLinkCriteria As String
  
    stDocName = "frmstockview"
 
    stLinkCriteria = "[Item]=" & "'" & Me![Combo7] & "'"
    stLinkCriteria = "[used?] = 0"
     
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    
    DoCmd.GoToRecord , , acLast
    [Forms]![frmstockview]![Text9].Value = [Forms]![frmstockview].Recordset.RecordCount
    DoCmd.GoToRecord , , acFirst

Thanx for your help and time.

[M Owen]

The other thing for you to look at is seting the CursorLocation to adUseClient. This will give you a record count ... USING the RecordCount method of the cursor even ...