Combo Box (One to Many Relationship)

[Martano0811]

I have a combo Box in a split form and would like the form to filter only on specific critera. For Example, there is one to many relationship to "Region" in my data and would only like to show all records in the "West" region. Currently when I use the combo box on a specific region it just moves to the next region in the form but includes all regions. I would like to show only the specific region (West, East, Central) Any assistance would be nice. (Im only using one table in this example)

 

[Martano0811]

This helps:

Im getting Error on this in the Record Source query...is there something wrong with the syntax?


SELECT [CPC Weekly Data].Region
FROM [CPC Weekly Data]
Where [CPC Weekly Data].Region = ' " & Forms!CPCREMilestoneFormReport!CboRegion & "'"
GROUP BY [CPC Weekly Data].Region
ORDER BY [CPC Weekly Data].Region;

 

[Martano0811]

Yes, it is Text, "error message in string in query expression": Where [CPC Weekly Data].[Region] = ' " & Forms!CPCREMilestoneFormReport!CboRegion & "'"

 

[Martano0811]

Great thank you Pat, one last thing a prompt is coming up ...."Enter Parameter Value" ....this shouldnt happen should it?