Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need Record Count? (A2k (9.0.3821) SR-1 Jet 4.0)

    A2k (9.0.3821) SR-1 Jet 4.0

    When I perform the following command, how can I get the record count result of the SQl?

    cboLicenseNo.RowSource = strSQL

    cblLicenseNo is a combo box populated by strSQL which contains the SQL statement

    Thanks, John

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Need Record Count? (A2k (9.0.3821) SR-1 Jet 4.0)

    For Combo Box & Listboxes you can use the ListCount property. Example:

    Dim n as Long
    n = cboLicenseNo.ListCount

    HTH

Posting Permissions

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