Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    May 2003
    Location
    cork, Ireland, Republic of
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    gettting a count value (access 2000 vb6)

    Hi I have a form which has a subform. Does anyone know of any way that I can get the record count when the user is finished adding to the continuous subform;
    ie the Data Control value

    thanks in advance for any help
    Sheila

  2. #2
    Lounger
    Join Date
    May 2003
    Location
    cork, Ireland, Republic of
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: gettting a count value (access 2000 vb6)

    After i posted my Q, i found that this works (FYI)

    Dim dCount As Integer
    Dim rst As DAO.Recordset
    Set rst = Me![subformName].Form.RecordsetClone
    dCount = rst.RecordCount

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •