I am completing an in-house developed Access system which will be used as our Courier Dispatch Ticket system. The Main form allows the user to input the information about a call. There is a continuous subform that updates based on a timer that displays the dispatch tickets entered for the cureent day. The records on the subform are color coded based on criteria in the record. For example, records that have been assigned are green. If there is no courier assigned, the record is blue. If the courier has completed the delivery, the record is white. As information is entered on the Main form, the subform is updated appropriately. This is working fine.
Now the manager of the Couriers would like to be able to click on an entry on the subform and have the data associated with that record displayed on the main form. Is there a way to do this? I've attached a screen shot of the form to help better explain what is desired.