I want to use a query for a subform that I'm making. The main form has a part number, and the subform will be a calculation of the item costs requried to make that particular part.
My idea is to use a parameter query taht will look up item costs based on the part number. Is there a way to run the query from the form, for the subform, and have the parameter automatically be equal to the part ID that is currently called up on the main form?
Please note that when the main form is intially called up, the subform that I'm trying to run the query is on a tabbed page that will not be queried until after the user clicks on the tab. This way the query will always have a value to use as it's parameter, if I can figure out how to make it look there.
Thanks in advance, and feel free to ask any questions if I havent been specific enough.