[AccessD] To open or not to open

Gregg greggs at msn.com
Tue Nov 30 22:38:15 CST 2004


I have a home made security system that addresses user rights based upon their function.  My method is to call a module that is on the on open of the form that will set the Add, Edit, and Delete rights based upon the user's function and the rights assigned to that function. My problem is... if a user does not have Add rights and there is no data for the criteria specified... I get an error "can't go to the specified record ".  I understand the form is being opened without data to go to and therefore will try to go to a new record and naturally will error because we have set ADD to no.  My question is what method can I use to avoid all that?  My wish is to issue a message that there is no data to view and return without opening the fom 


More information about the AccessD mailing list