Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Filter For" menu item and filtering? 1

Status
Not open for further replies.
knovak

knovak

Programmer
Dec 18, 2001
17
US
If a user right-clicks on a field and enters criteria in the "Filter For" box, how do I keep them on the same record if the criteria they enter is not in the current record set. I can't find any examples on MSDN that do this.

Thanks,

Kyle
 
Sort by date Sort by votes
This should do the trick...

Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)

If DCount("*", Me.RecordSource, Me.Filter) = 0 Then Cancel = True

End Sub
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
6K
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
2K
dhookom
dhookom
swicor
  • Locked
  • Question
Exact match using access upper and lower case
Replies
0
Views
1K
swicor
swicor
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top