How to hide a record?

[Guest]

Is it possible to hide a record in query form?

After users do a query I check if this record should be displayed or not.
then hide it if need be.

Thank you,
-Me

 

[jahoobob via AccessMonster.com]

Add a hidedata field to the table in Yes/No format. You check the records to
be hidden and then use a select query that shows all records except those
that have Yes in the Hide field. and let the users see data via that query.

 

[Guest]

Hi Ja...

Thanks for the reply!
Sorry I forgot to add earlier on that I will need to display these records for
some users based on their userid.

I am able to hide them, but how to unhide for few others?

Thanks again,
-Me