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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Me.filter is not working for a NOT EQUAL condition

Status
Not open for further replies.
Pack10

Pack10

Programmer
Feb 3, 2010
495
US
In a form open procedure, I am filtering on a condition.
me.filter = "(Status <> 'Archived') Or (status <> 'Withdrawn')"

This is not working, If I change the <> to =, then it works.
What am I doing wrong.

Thanks
 
Sort by date Sort by votes
oops....I think I figured it out. I needed an "AND" condition.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
554
Kennelbloke
Kennelbloke
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
473
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
512
TrekBiker
TrekBiker
MacroAlan
  • Locked
  • Question
Navigation Bar is too short to read
Replies
5
Views
415
dhookom
dhookom
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
347
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top