Linking Subforms together?

[Jocky]

My problem is as follows:

If an order entry DB MS Access 97.

I have a form [Orders] used to enter the order details.

I have a subform (default view - single form) within this [Order Details1]
that is used to enter the line info, e.g product, qty, price, etc.

I have another subform (default view - datasheet) [Order Details2] within
[Orders] that displays all the line items for the particular order.

PROBLEM

When I enter the line info via [Order Details1] it does not update [Order
Details2] automatically, I need to click in the datasheet and sort it for it
to be updated.

I would also like to be able to click on a record within [Order Details2]
and the relevant item info be displayed in [Order Details1]

Is this possible???

Cheers,

 

[eclipsetech]

I'm having a similiar issue and have not yet resolved it. I'm using Access 2002 and have two subforms (both datasheet views). Subform1 is the master and Subform2 is 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. I know that this will work since there is an example in the Northwinds sample database. I have had this work between a main form and a subform, but I cannot get it working between 2 subforms. Anyway, you may want to check and see if you have your master and child properties set and it may work for you.

If anyone as successfully linked two subforms that are set up as datasheets, I'd appreciate input on how its done.