Synchronization

[lad5ko via AccessMonster.com]

Hi,

I have Table Orders as Subform in Datasheet View with fields ID_Order,
Customer, Date, Task. Field Customer is Combo box (Source from Table
Customers). I need, when I select some Customer in this Subform this Customer
with much more data Apears in another Subform in same Form. (Synchronization
from Subform in Datasheet view.)

Thanks i advance.

lad5ko

 

[tina]

add an unbound textbox control to the main form (you can set its' Visible
property to No, if you don't want it to show up in form view); i'll call it
txtCustomer. for example purposes, i'll call the first subform control
ChildA, and the second subform control ChildB. set the ControlSource of
txtCustomer to

=[ChildA].[Form]![Customer]

set ChildB's LinkMasterFields property to

[txtCustomer]

and make sure the LinkChildFields property is set to the name of the
"customer" foreign key field in ChildB's subform's recordsource.

hth

 

[lad5ko via AccessMonster.com]

Hi,

Thank you for your time, but it do not work. Maybe because my field Customer
in table Orders is foreign key field. When I try vice versa and select
customer - I can select all his Orders from second Subform. But I need by
selecting Customer from Subform Orders set in Subform Customer this Customer.

lad5ko

add an unbound textbox control to the main form (you can set its' Visible
property to No, if you don't want it to show up in form view); i'll call it
txtCustomer. for example purposes, i'll call the first subform control
ChildA, and the second subform control ChildB. set the ControlSource of
txtCustomer to

=[ChildA].[Form]![Customer]

set ChildB's LinkMasterFields property to

[txtCustomer]

and make sure the LinkChildFields property is set to the name of the
"customer" foreign key field in ChildB's subform's recordsource.

hth

Hi,

[quoted text clipped - 7 lines]

lad5ko