Link to home
Start Free TrialLog in
Avatar of barbotte
barbotte

asked on

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.
Avatar of HappyFunBall
HappyFunBall

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"
Avatar of barbotte

ASKER

???

Just under the line
SELECT Form = "MyForm";
ASKER CERTIFIED SOLUTION
Avatar of HappyFunBall
HappyFunBall

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you for the fast answers!
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"

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