However, I tried to use the principal you described to get data from a specific query by clicking on a button instead of making selection from a combo box.
Here is the code I wrote, but it doesn't work. I definitely missed something. Any suggestion?
Private Sub cmdAddToColnect_Click()
DoCmd.OpenForm "frmMainForm", acNormal
Me.RecordSource = "qryAddToColnect"