Hi all,

I have a form called "orders by customer" by customer, on this form I
have a sub form called "orders by customer subform".

At the moment I have it that you double click an order in the "orders
by customer subform" and it opens up another form called "orders" to
the order you double clicked on.

The code I use is

Dim stDocName As String
   Dim stLinkCriteria As String
   strDocName = "orders"
   strWhere = "[orderid]=" & Me![OrderID] & ""
   DoCmd.OpenForm strDocName, , , strWhere

What I want to do is now put the "orders" form as another subform in
the main form "orders by customer" and when you double click on
"orders by customer subform" on a order it refreshes the other sub
form "orders" to show the details of that order.

Does that make sense?

Thanks