Applyfilter

[Parker]

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

Thankyou

 

[John W. Vinson]

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

Thankyou

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

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

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Parker]

From: John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
Newsgroups: microsoft.public.access.formscoding
Subject: Re: Applyfilter
Date: Sun, 16 Sep 2012 15:18:40 -0600
Organization: Wysard of Information
Reply-To: (e-mail address removed)
Message-ID: <[email protected]>
References: <[email protected]>
X-Newsreader: Forte Agent 6.00/32.1186
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: static-74-41-143-137.br1.mcl.id.frontiernet.net
X-Trace: news.bnb-lp.com 1347830323
static-74-41-143-137.br1.mcl.id.frontiernet.net (16 Sep 2012 17:18:43
-0400) Lines: 21
X-Authenticated-User: pa1113
X-DMCA-Complaints: Send abuse or DMCA complaints to (e-mail address removed)
X-DMCA-Complaints: The subject line should contain only the 4 letters
DMCA Path:
border1.nntp.dca.giganews.com!border4.nntp.dca.giganews.com! border2.nnt
p.dca.giganews.com!nntp.giganews.com!news.bnb-lp.com!not-for-mail

That worked. Thank you.