1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Dim WhichOrderNrSystem As Long
Dim WhichStyleSystem As Long
WhichOrderNrSystem = Me![WhichAllOrder]
WhichStyleSystem = DLookup("StyleSystem", "Order", "OrderNrSystem = " & WhichOrderNrSystem)
'------------------------------------------------------------------ Style
DoCmd.OpenForm "StyleOrder", , , "StyleSystem = " & WhichStyleSystem
Forms![StyleOrder].SetFocus
Forms![StyleOrder]![StyleSystem].SetFocus
'------------------------------------------------------------------ Order
Forms![StyleOrder]![Order].SetFocus
Forms![StyleOrder]![Order].Form![OrderNrSystem].SetFocus
DoCmd.FindRecord WhichOrderNrSystem, , , , , acCurrent
Forms![StyleOrder]![Order].Form![RemarkCustomer].SetFocus
Forms![StyleOrder]![WhichAllOrder] = ""
'------------------------------------------------------------ Relicat
Forms![StyleOrder]![Order].Form![Bt_Relicat].Caption = "To be ordered: " & DLookup("QuantityInitial", "GetRelicat", "OrderRank = 0 ") - DSum("QuantityDelivered", "GetRelicat") & " pcs (" & DCount("OrderNrCustomer", "GetRelicat") - 1 & " relicats)" |
Partager