One Form To Many Forms

Question

I have 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.

Answer 1

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

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