I want to filter a form on the [ID] field and then open another form at that Record No. However, I also want to use the value in the [Test Group] field to determine which form to open. For example if [Test Group] = FR open 'flammable fabric' Form, if Test Group = FC open 'Fabric Colour' Form, and so on. How can I create this for a series of Forms??
I'm now using Access 2010