How to hide information

[Niklas]

I have a form holding data....I do not want to everyone
see e.g. price information. Is it ok to hide price data on
the form or should I do that somewhere else (table,
query...) and what would be a good way to do that?

 

[matt perpick]

i just put text boxes on a page, link them to a field and make the page
invisible. You actually may not even need to put the boxes on a page, just
get at the fields with Item.UserProperties("my field")

 

[HSalim]

There is hardly any use in hiding information in a form when the tables
behind it are available for viewing.
This is a fairly large subject. it involves designing your application for
multiple users, setting up user accounts and security
and all the things that go with it.
Get a good book on Access.