[AccessD] Has Record Changed?

Hi Arthur
Assuming it's a bound form then

If Me.Dirty Then......

achieves this.

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

>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com 
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
>Arthur Fuller
>Sent: 29 July 2008 21:25
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Has Record Changed?
>
>
>The form presents the data in read-only fashion. There's a 
>button to click if you want to edit the data. That button 
>enables and unlocks all the controls. The user changes nothing 
>and clicks Save. How can I determine whether anything has 
>changed? (The reason I need to know this is that the current 
>code updates two fields, LastUpdate and UserName, when you 
>click Save, and I want to circumvent this if nothing has changed.
>
>TIA,
>Arthur
>-- 
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>