thanks tom and rod for sharing..
the function worked..
u are right rod... the enter new form did not prompt to save as i change to difference vp... i need to think carefully...
then how to design the VP more effectively and easy to maintain:
example: there are 10 link to access the data (enter form, edit form, list, report etc)
manager: access everything
operation 1: only can access 1,4,5
operation 2: only can access 1,2,3,4,5
operation 3: only can access 5,6,7,8
should I just design I VP for all and use the access level to control or i design every user one VP according to the requirement to login. But in the future, if operation 3 want to access no 9, then I need to transfer the updated file again to the server. any way to reduce the work load?
additional of that, my client want a form for the manager to check and uncheck those function to access by their user. How do I do the form and edit the access levels file?
thanks