[AccessD] To open or not to open

Hi Gregg:

Maybe try something as simple as catching the error code and managing it
yourself.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gregg
Sent: Tuesday, November 30, 2004 8:38 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] To open or not to open


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
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com