Discussion in 'Access Forms Coding' started by Parker, Sep 16, 2012.

  1. Parker

    Parker Guest

    When I use the applyfilter method how do I check to see if any records were
    returned? I'm using Access 2002 sp3.

    Parker, Sep 16, 2012
    1. Advertisements

  2. I presume this is on a Form? Check the form's recordsetclone:

    If Me.RecordsetClone.RecordCount > 0 then
    ' records were returned
    ' none were
    End If

    John W. Vinson [MVP]
    Microsoft's replacements for these newsgroups:
    and see also
    John W. Vinson, Sep 16, 2012
    1. Advertisements

  3. Parker

    Parker Guest

    That worked. Thank you.
    Parker, Sep 16, 2012
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.