[AccessD] Unbound Form Check For Changes

Hi Vlad

Use the index or name of the control as the key in the Collection. Should be pretty easy.

/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 16:01
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] Unbound Form Check For Changes

Hi Gustav,

Can you give me an example of the collection and value of the controls
please?

It's 2am here, I'm off to bed. Thanks everyone for your help. I'll talk to
you guys tomorrow...

Thanks

Vlad

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Sunday, 23 March 2014 1:34 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Unbound Form Check For Changes

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