SQL "Where" command for Subform

[Dan Kenton]

I have a subform with a field that contains a drop-down list of product IDs. I wrote a macro and assigned it to a button that, when pressed, opens up the the inventory master form displaying each product's attributes along with a picture of the item. I am trying to use the WHERE command in the macro to sync the chosen product ID in the subform list to the inventory master form when it pops on the screen. Unfortunately, I keep getting a parameter box asking which productID I want. Here's the language used:

[productID] = [forms]![frm inventorymster]![productid]



I've had this work on forms without subforms so perhaps this is my problem?

Thanks for the help!

[orange]

Here's a link to the various ways to refer to Forms and subforms

http://www.mvps.org/access/forms/frm0031.htm

[Dan Kenton]

Thanks Orange but this appears to be all VBA. Can't this be done in SQL within the macro's WHERE field?