How to display Max(subfrm_field) on another sub form ?

[araskas]

My tables are customers (1-many) with Orders,
Orders ( 1- many) with OrderDetais
I have a main form (frmMaincustomers) with 2 synchronized subfroms
(subfrmOrders, subfrmOrderDetails).
Order Detail has a field called Shipped Date.
I want to display the maximum (shipped Date) from subfrmorderDetails on subfrmOrders .
Any tips ?
Why can't I create a text box on the subfrmOrders and set its control property to
Max(Me.Parent![subfrmOrderDEtails]("Shipped Date"))
I now have a text box called Temp1 on subformDetail with control = max([Shipped Date])
Similarly
on main form I have text box temp2 = subform("Temp1")
On Orders Sub form I have Temp3 = parent("temp2")




[This message has been edited by araskas (edited 08-09-2001).]