I am trying to make my Caption, i.e. Label show if ALL orders have been Posted (Order Status) or not. This is my subform and fired on the OnCurrentEvent.
Of course since the subform is a continuous form when the user clicks on another record the code does not work, it only works for the first time.
lblstatus used as a Caption. Is on subform
OrderDetailsSubform subform on main form OrderDetails
DoCmd.RunCommand acCmdSelectAllRecords
If [OrderStatus] = "Not Posted" Then
lblstatus.Caption = "Some Orders Not Posted"
Else
lblstatus.Caption = "All Orders Are Posted"
End If