Open another form from a clicked value in a subform in Access 2010
Posted on 2016-08-21
I have a form (CustomerInfo) with a subform (WorkOrders) linked by CustomerID. I want to be able to click on an order on the subform to open the associated work order form. In the subform click event, I passed the value to a textbox in the main form (CustomerInfo). From there I built a macro to open the associated work order form but somehow It didn't work. It just opened a blank form. Any help is appreciated.
This is my open form macro (assigned to a command button on the main form
Form name: WorkOrder
Where condition = [Forms]![WorkOrder]![WorkorderID]=[Text116]