1

Topic: Two subordinate forms

Hello!
There are 2 subordinate forms.
At change of number of the document in the first , record c the same number in another  otobrazhaetsja/disappears. Here the problem is not present. A problem if in the first  to delete record the second  is updated only through F5 (manually).  it is impossible.
Tried:
Forms! Principal! 2.Form. Requery
Forms! Principal! 2.Form. RecordSource = Forms! Principal! 2.Form. RecordSource
Operation produces an error "is not supported in transactions"
Forms! Principal! 2.Requery
Forms! Principal! 2.Refresh
- Does not help

2

Re: Two subordinate forms

;
Data set different.
In 2 the data which do not participate in 1 are displayed.
If in the first  to bring number of the document from  2 in 2 record disappears. If to delete number dock in 1 then in 2 it is displayed. And if to delete not the document, and record in 1 in 2 it is not displayed, it is necessary to update manually.

3

Re: Two subordinate forms

VaRas, you use what events? In subforms different tables are used?

4

Re: Two subordinate forms

Anatoly (Kiev);
Yes, in subforms different tables.
To the principal form it is connected 1.
2 Without a binding to the principal.

5

Re: Two subordinate forms

Anatoly (Kiev);
Form_BeforeUpdate
Form_Delete

6

Re: Two subordinate forms

VaRas wrote:

Form_BeforeUpdate
Form_Delete

it is wrong.
Instead of Form_BeforeUpdate - Form_AfterUpdate
Instead of Form_Delete - Form_AfterDeleteConfirm (at the status - record is remote)

7

Re: Two subordinate forms

Anatoly (Kiev);
Delivered in
Form_AfterDelConfirm
Forms! Principal! 2.Form. RecordSource = Forms! Principal! 2.Form. RecordSource
Forms! Principal! 2.Requery
Changes are not present
Form_AfterUpdate ()
Forms! Principal! 2.Form. RecordSource = Forms! Principal! 2.Form. RecordSource
Operation produces an error "is not supported in transactions" (at record removal in 1)

8

Re: Two subordinate forms

VaRas;
Lay out the problem form and necessary tables and what result want to see