[AccessD] Unbound Form Check For Changes

Gustav Brock gustav at cactus.dk
Sat Mar 22 09:34:27 CDT 2014


Hi Vlad

When you have filled the controls, create a Collection of the Controls' values by looping these and add them if they are textboxes or checkboxes.
To check for changes, loop the Collection and compare with the Value property of the controls.

To reset, loop the controls and if they are textboxes or checkboxes set Value to Null.

/gustav

________________________________________
Fra: accessd-bounces at databaseadvisors.com <accessd-bounces at databaseadvisors.com> på vegne af ACTEBS <actebs at actebs.com.au>
Sendt: 22. marts 2014 15:18
Til: accessd at databaseadvisors.com
Emne: [AccessD] Unbound Form Check For Changes

Hi Group,

Looking for an elegant way of checking whether any changes have been made in
an unbound form. This form has mixture of about 150 text and combo boxes.

I'd like to be able to check whether the user has made changes to any field
and if so prompt and ask if they want to save the changes. Also, once saved,
an elegant way to clear all the values in the form so the user can add a new
record.

Tanks in advance.

Vlad


More information about the AccessD mailing list