Synchronization

  • Thread starter Thread starter lad5ko via AccessMonster.com
  • Start date Start date
L

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
 
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,

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,
Click to expand...
[quoted text clipped - 7 lines]
lad5ko
Click to expand...
Click to expand...
 
Back
Top