combobox subform to form (1 Viewer)

Using Access 2007

Created a form [FRMActivitySelect] to select an item from a dropdown combobox

On same form, command button to take me to a report to use this selected item.

this is my query code for report

SELECT DISTINCT ApptHistTable.DateAttended, [LastName] & ", " & [FirstName] AS Name, ActivityListTable.ID, ActivityListTable.Activity, EpisodeTable.Referredby, EpisodeTable.[EpisodeID#], ApptHistTable.Status
FROM ClientData INNER JOIN (ActivityListTable INNER JOIN (EpisodeTable INNER JOIN ApptHistTable ON EpisodeTable.[EpisodeID#] = ApptHistTable.EpisodeID) ON ActivityListTable.ID = ApptHistTable.Activity) ON ClientData.ClientID = EpisodeTable.ClientID
WHERE (((ApptHistTable.DateAttended)=[Enter Date]) AND ((ActivityListTable.Activity)=[Forms]![FRMActivitySelect]![selactivity]));



[selectivity] is the name of the field that holds the selection from the form [FRMActivitySelect]

I get no records.
I know it's got to be something with the bound columns? There are 2 columns : ID and Activity in the combobox

Any and all help welcome.

you don't use the name of the field, you use the name of the combobox.
SOMETIMES they can be the same name, but not always.
Is your combo box NAME = selectivity?

the combobox is named selactivity on the form I created.