Subform vs "Open Form" button issue

[wchelly]

I have a form to enter shipment data and a subform to enter and view serial numbers for that shipment. The subform displays only the related serial numbers for that shipment.

I would like to just use an "Open form" button to open the serial numbers form, however, when I use the button it opens the form and displays all the serial numbers for all of the shipments. It doesn't select only the ones related to that specific shipment...at least not with out another query ....


Does anyone know if there is a way to open the form with only the serial numbers for that shipment without creating a whole separate query?

 

[pbaldy]

Is this what you're after?

http://www.baldyweb.com/wherecondition.htm

 

[wchelly]

That's it! I couldn't open the link from work...they have it blocked for some reason but I was able to do a search for "wherecondition" discovered the solution.

I added a where condition "[trackPackages]![ShipperID]=[Forms]![Add/Edit/Delete/grayscale new]![ShipperID]" to the button macro

Thanks again!

 

[pbaldy]

Happy to help!