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.
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.