Global Variables

[kingsgambit]

I am building a database for a small IT company so they can enter records for tip and tricks on how to fix things. They enter a record by selecting a Category,Subject,Topic then enter the details.I have build a search form so they can lookup any record. They want to be able to have a tickbox on the new record entry form that will say "Private" so only certain people can view it i.e ftp details of clients.
I am told I need a global variable, so that a query could check who is logged on against the record to see if they are allowed to view it, if not Msg "No Access".
I don't know anything about variables or how to produce a query that will check these things, can anybody help me. Show me in simple steps please

 

[doulostheou]

I don't know much about global variables, but I can tell you how I have accessed needed information in the past. I just create a separate form that houses let's say all the employee numbers and maybe a code that would indicate what level of access they have. Then before going to a new record, it would open the form invisibly, use docmd.findrecord to go to appropriate employee. You can then reference that form in your code and either return an appropriate msgbox or allow access to the record.

I may be way off on what you are wanting, so I'm not going to bother to write out the code step by step. But feel free to e-mail me if it sounds like the above may help and need more info on setting it up.

 

[Rich]

Didn't you see the two answers to your previous post? Please continue with one thread so members can follow what's already been suggested. If you don't understand what's being suggested then just say so.