D
David Gottholm
Im relatively new to Access and could use some help. I'm
using Access 2002 and have two subforms (both datasheet
views) on a main form. I want Subform1 to be the master
and Subform2 to be the detail. In Subform2 I set:
Link Child Fields: OrderID
Link Master Fields: [Subform1].Form![OrderID]
This should link the two subforms but when i click on a
record in Subform1 it does not automatically change
Subform2 data to match based on the OrderID key. It does
link them, but just to the first record in Subform1. I
want the Subform2 to change based on the record I select
on the Subform1.
There is a similiar example in the Northwinds sample
database (Customer Orders) that works. It also has a
master record on the main form but besides that, my two
subforms are similiar to the two subforms in that example
(except mine don't work) I have had this record
synchronization work between a main form and a subform,
but I cannot get it working between 2 subforms where both
are datasheets.
If anyone as successfully linked two subforms that are set
up as datasheets, I'd appreciate input on how its done.
using Access 2002 and have two subforms (both datasheet
views) on a main form. I want Subform1 to be the master
and Subform2 to be the detail. In Subform2 I set:
Link Child Fields: OrderID
Link Master Fields: [Subform1].Form![OrderID]
This should link the two subforms but when i click on a
record in Subform1 it does not automatically change
Subform2 data to match based on the OrderID key. It does
link them, but just to the first record in Subform1. I
want the Subform2 to change based on the record I select
on the Subform1.
There is a similiar example in the Northwinds sample
database (Customer Orders) that works. It also has a
master record on the main form but besides that, my two
subforms are similiar to the two subforms in that example
(except mine don't work) I have had this record
synchronization work between a main form and a subform,
but I cannot get it working between 2 subforms where both
are datasheets.
If anyone as successfully linked two subforms that are set
up as datasheets, I'd appreciate input on how its done.