Hi,
I have a combo box on a form which displays records in a subform (datasheet view). the combo box is a list of containers - And the subform shows the different products numbers that are in that containers..
Now, sometimes the user is required to know on which container was a particular product carried before.
Is there a way to click on the Product# field in the datasheet view which triggers another subform/subreport that shows this information?
any other suggestions are highly appreciated. Thanks!
I have a combo box on a form which displays records in a subform (datasheet view). the combo box is a list of containers - And the subform shows the different products numbers that are in that containers..
Now, sometimes the user is required to know on which container was a particular product carried before.
Is there a way to click on the Product# field in the datasheet view which triggers another subform/subreport that shows this information?
any other suggestions are highly appreciated. Thanks!