Hey guys, i'm sorry if this question has come up before and also i apologize if it is a rediculously easy solution, i have spent many many hours trying to work it out and searching and reading for the solution but couldn't find it.

I am setting up a staff hours record and everything is ready to go bar one thing. I want to setup a button in which the user clicks to open up thier hours for the week but must enter a username and password first (to stop other staff from editing pr viewing others hours).

I tried using a password script but this doesn't seem to have anywhere where i can set the passwords and i can just hit cancel and the staff can still enter in the information.

Any help would be greatly appreciated

You just need to set up Record Level Access (RLA) such that a user sees only his/her own records. When a user creates a record, the Account Name should be automatically entered into a field (call it RecOwner). Then when RecOwner matches Get(AccointName) the user sees the record. Otherwise, not.

HTH

Steven

Thanks very much for your responce, i'll give it a go