Subform datasheet view/Clickable

[umair434]

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!

 

[umair434]

Thank You! it works really well. Just wondering, is there a way to open the form as a subform underneath? like it becomes visible only if there is there is a matching product?

 

[umair434]

I just revised the requirements of this application and realized that the second subform does not have to be invisible. How would I approach the issue that:

the user clicks on the productID field in the 1st subform, and this populates the second subform with the productID selected?


thanks for your time Pat

 

[umair434]

I am not duplicating the data.


Would you mind to have a look at the database if I posted it here?

Here is how application should work:


1) User selects a container # from the combo box on the main form.

2) this popuates the first subform with the list of products (datasheet view)

3) When the user clicks/double clicks on a product #, the second subform (which is located on main form as well) gets populated as well, with the matching product # and other relevent details.


Do I make sense?

 

[umair434]

Thanks! that guided me in a right direction and I almost have what I am looking for.


Just one thing: When the user selects a container number in the combo box, the first subform is populated with multiple product numbers. Each product number has to have a comment (Comment is a field in this subform). Now how can I make sure that users can only save the record if they enter comments for all the product in the first subform?


I tried:

If IsNull(Me!frmsubform.Form![Receiving Comment]) Then

MsgBox "Please comment on the Product", vbOKOnly
Cancel = True

but that only works if no comment has been added for any of the product#.


In other words, code is only run if all comments are filled for every product. Otherwise we get a msg box.


Thanks for being patient!