I have a cboSpec2 on frmExerciseSelector which displays a list of results, when the user selects a result it's suppose to open frmresults, which it doesn't.
I can get frmresults to open by it's self to display the correct results but I need frmresults to open when a selection from cboSpec2. I've been reading around and it looks like recordset clone maybe the answer, but I can't get the syntax to work - I would appreciate any help.
the frmresult works with this code: SELECT DISTINCTROW tblExercise.ID, tblExercise.idMuscleGroup, tblExercise.exercisename, tblExercise.Instructions, tblExercise.advinstructions, tblExercise.ImagePath, tblExercise.Equipment FROM tblExercise WHERE (((tblExercise.ID)=[Forms]![frmExerciseSelector]![cboSpec2]));
I can get frmresults to open by it's self to display the correct results but I need frmresults to open when a selection from cboSpec2. I've been reading around and it looks like recordset clone maybe the answer, but I can't get the syntax to work - I would appreciate any help.
the frmresult works with this code: SELECT DISTINCTROW tblExercise.ID, tblExercise.idMuscleGroup, tblExercise.exercisename, tblExercise.Instructions, tblExercise.advinstructions, tblExercise.ImagePath, tblExercise.Equipment FROM tblExercise WHERE (((tblExercise.ID)=[Forms]![frmExerciseSelector]![cboSpec2]));
