[AccessD] A2K: Stop User from oving to new record

Hiya Darren, how're ya doing?

Use the form's OnError event for this. If you first of all stick in there a:

MsgBox DataErr

That'll give you the error number. You can then test for that and do
whatever your heart desires.

See you when we emigrate :-)

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
> Sent: 05 April 2004 03:27
> To: AccessD List
> Subject: Re: [AccessD] A2K: Stop User from oving to new record
> 
> 
> Hello all
> In relation to stopping a person moving to another record 
> before the previous one is complete... I put some validation 
> rules on the table. Now it's working fine.....almost
> 
> Does anyone know the err number Access throws up when table 
> level validation is not met? If anyone does know, how do I 
> trap it at form level and throw up my own message box?
> 
> Many thanks
> 
> Darren
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>