One Form To Many Forms

I hav开发者_Python百科e form with 1 button. when you click on the button 3 others appear which relate to product colours red green or blue.

At the moment when you click on a colour button it opens a form just for that colour product.

Is it possible to have just one colour form that opens when any colour button is clicked but will filter the parts related to the colour.

The arguments for the OpenForm method of DoCmd include Where, so you can have something like:

 DoCmd.OpenForm "FormNameHere",,,"Colour='" & Me.txtBoxWithColourName & "'"