Jim Lawrence
accessd at shaw.ca
Fri Dec 22 10:07:37 CST 2006
Hi Martin: First: the field's property 'text' and 'value' contents will be different if there has been any change in the field. Second: the content of the current record, in the recordset, used to populate the form will have differences. Third: The 'dirty' property will be set if there are any values changes in the form. One or all of these can be checked. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Friday, December 22, 2006 5:10 AM To: Access Developers discussion and problem solving Subject: [AccessD] Unbound Again Back to the unbound edit So the idea I am using is to 1. Click The Edit Button 2. Unlock fields 2. Change edit caption to save So the suer changes one field. Do you just simply update the whole record ot do you test each field and only chane the one edited? Or is there any issue with either? Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477