I have an Orders form, without any underlying related tables.
Located in the upper half of this form, I have a sfrmOrders in datasheet view with a ssfrmOrderDetails as a subform embedded in it. On the lower half of the form, I have a sfrmOrderProcessing in single form view.
The goal is for the user to start with a list of open sfrmOrders, expand the plus sign next to each order to see all the items that need to be processed in that order shown in the sfrmOrderDetails datasheet, then click on a line in the sfrmOrderDetails and populate the sfrmOrderProcessing area below with for editing.
The link between the sfrmOrders and sfrmOrderDetails works fine, but for some reason I can't get the sfrmOrderProcessing to update when clicking on the sfrmOrderDetails.
I tried using a link at the top of the Orders form called [txtLink] pointing to the control =[sfrmOrders].[Form]![ssfrmOrderDetails].[Form]![OrderDetailID]
It works, within only on one record of the sfrmOrders datasheet, and does not update when going between sfrmOrders records.
The Orders form has no underlying tables because it needs to combines the datasheet views with a single form view. The top level form is sfrmOrders. Is there another way to do it?
The sfrmOrders (tblOrders) has the list of main orders. each of which can contain many different parts in ssfrmOrderDetails (tblOrderDetails). The sfrmOrderProcessing has the information that an employee needs to know to laser mark each part (tblOrderProcessing), updating the status of the order as each part is marked in the overall order. It is a single form, because it contains print buttons and photos that cannot be displayed in datasheet view. The top two datasheet forms are mostly for navigation, being able to see the order and order details in a selectable tree view.
What am I missing?
Located in the upper half of this form, I have a sfrmOrders in datasheet view with a ssfrmOrderDetails as a subform embedded in it. On the lower half of the form, I have a sfrmOrderProcessing in single form view.
The goal is for the user to start with a list of open sfrmOrders, expand the plus sign next to each order to see all the items that need to be processed in that order shown in the sfrmOrderDetails datasheet, then click on a line in the sfrmOrderDetails and populate the sfrmOrderProcessing area below with for editing.
The link between the sfrmOrders and sfrmOrderDetails works fine, but for some reason I can't get the sfrmOrderProcessing to update when clicking on the sfrmOrderDetails.
I tried using a link at the top of the Orders form called [txtLink] pointing to the control =[sfrmOrders].[Form]![ssfrmOrderDetails].[Form]![OrderDetailID]
It works, within only on one record of the sfrmOrders datasheet, and does not update when going between sfrmOrders records.
The Orders form has no underlying tables because it needs to combines the datasheet views with a single form view. The top level form is sfrmOrders. Is there another way to do it?
The sfrmOrders (tblOrders) has the list of main orders. each of which can contain many different parts in ssfrmOrderDetails (tblOrderDetails). The sfrmOrderProcessing has the information that an employee needs to know to laser mark each part (tblOrderProcessing), updating the status of the order as each part is marked in the overall order. It is a single form, because it contains print buttons and photos that cannot be displayed in datasheet view. The top two datasheet forms are mostly for navigation, being able to see the order and order details in a selectable tree view.
What am I missing?
