1

Topic: Check of changes in the subordinate form.

How to check up that in the subordinate form there were changes of records.
In the subordinate we put ticks and it is imported the data.
In the same place there is a button to save the data.
But as well as during what moment to catch that the data in some records exchanged, and to ask the user to save changes.
As then this data is transferred to the table for storage.
But if not to save the data they remain on the form, and at its closing - disappear type.
------------------------------------------------------------------------
Thanks for the answer.

2

Re: Check of changes in the subordinate form.

58, so not?

Private Sub Form_Dirty (Cancel As Integer)
......
End Sub

3

Re: Check of changes in the subordinate form.

vixxa;
There is no this event for some reason.
I do changes, I pass in the main form, again I do changes - responses - a zero.

4

Re: Check of changes in the subordinate form.

58 wrote:

there is no this event for some reason.
I do changes, I pass in the main form, again I do changes - responses - a zero.

And  in studio feeblly? For  do not so

5

Re: Check of changes in the subordinate form.

58 wrote:

vixxa;
There is no this event for some reason.
I do changes, I pass in the main form, again I do changes - responses - a zero.

More truly, happens, but at everyone  in the subordinate form.
And it would be necessary after all changes and an output from the subordinate - to ask:

Can we save changes?

6

Re: Check of changes in the subordinate form.

vixxa wrote:

58, so not?

Private Sub Form_Dirty (Cancel As Integer)
......
End Sub

You are Generally right.
It is necessary a variable  and to change its value at the moment of changes, and then to check its value about change.

7

Re: Check of changes in the subordinate form.

;

DESCRIBED
Situation.
:-)

8

Re: Check of changes in the subordinate form.

Similar I was processed.
All thanks.
All...
Rest.!

9

Re: Check of changes in the subordinate form.

58 wrote:

after all changes and an output from the subordinate

Sub Form_LostFocus ()

Any guessing on a coffee thick....

10

Re: Check of changes in the subordinate form.

wrote:

try event Form_BeforeUpdate , it is possible to cancel record saving. But for everyone...

Carries to you, .... Without words understand the scandalous smile