Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

In a view : hiding some records according to the value of a field

An easy one... at least, I guess!

Is there any way to hide some records (not a column, but records) according to the value of a field?

Example:

I've got the field "TheStatus" in a form, and if the value is "Not Yet Assigned", then I don't want to see those records.  But I want to see all the others.
0
barbotte
Asked:
barbotte
  • 2
  • 2
  • 2
1 Solution
 
HappyFunBallCommented:
You just need to set your selection formula for the view to show only the documents you want.

The formula would be this in your example:

TheStatus != "Not Yet Assigned"
0
 
barbotteAuthor Commented:
???

Just under the line
SELECT Form = "MyForm";
0
 
HappyFunBallCommented:
Ok, yes

Change the formula to this:

SELECT Form = "MyForm" & TheStatus != "Not Yet Assigned"
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
barbotteAuthor Commented:
Thank you for the fast answers!
0
 
RanjeetRainCommented:
On the dot HFB. BUt, I would add something. THis would be better when combined with the Form slection formula (Otherwise barbotte will have to post another question) ;)

SELECT FORM = "Form_Name" & TheStatus != "Not Yet Assigned"

0
 
RanjeetRainCommented:
Oops! Sorry. I left this open while commenting in the other thread. All well :)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now