Try to avoid using macro. In QV there is a pretty flexible mechanism for triggering specific action according to current activity. In you case I can suggest to use triggers on Sheets.
1. Right click on any free space on specific sheet and select Properties from context menu.
2. Go to Triggers Tab.
3. Click Add Action(s) button for OnActiveSheet event trigger
4. Click Add button
5. Select ActionType = Selection and Action=Select in Field
7. Type a Field name and Search string for appropriate data selection
If you want to work with variables there is another Action Type for this. Play with it and your application will have great performance.
I have actually tried that trigger. The Macro or variable part is where I get stuck.
What I want is a variable to pick up the spec group from the previouse tabs and select that same group out of the list on the activity page.
What is happening is that the SR Spec group is being pulled into the Activity tabs and messing with the data. Right now my only option is to set a trigger to clear the spec group and have them reselect it.