Hey,
I have a form with two subforms on it and they are linked together so that when someone clicks on a line item in the table, the other table automatically updates to show the notes pertaining to that line item. Table 1 has the following columns: Item ID, Nomenclature, Manager, and Status. What I would like to do is have another form pop up when the status for a line item in Table 1 is changed to "submitted" so that the user can add the Item Value and Submittal date information as soon as it is changed to submitted. Is this possible? if so, how would you recommend going about doing this? any help is appreciated. Thanks!
I have a form with two subforms on it and they are linked together so that when someone clicks on a line item in the table, the other table automatically updates to show the notes pertaining to that line item. Table 1 has the following columns: Item ID, Nomenclature, Manager, and Status. What I would like to do is have another form pop up when the status for a line item in Table 1 is changed to "submitted" so that the user can add the Item Value and Submittal date information as soon as it is changed to submitted. Is this possible? if so, how would you recommend going about doing this? any help is appreciated. Thanks!