Hi Guys
This is related to another post.
Can anyone tell me what I'm getting wrong with this code? I can't fathom it as it appears to be identical to the code I've used in another combo yet it works in the other combo.
SELECT [Trainers_Projects].[Trainer_Name] FROM Trainers_Projects WHERE Project_Title=[Forms]![Resourcing].[Cmb_Project_Title] ORDER BY [Trainer_Name];
The combo is on a form called Resourcing and the idea is that once someone picks a Training_Type then only courses matching that type are available. (That bit works) Once they select a Project_Title then only Trainer_Names that can deliver that project are available. (This bit doesn't)
I've attached a basic model of the db that you can look at.
Cheers
This is related to another post.
Can anyone tell me what I'm getting wrong with this code? I can't fathom it as it appears to be identical to the code I've used in another combo yet it works in the other combo.
SELECT [Trainers_Projects].[Trainer_Name] FROM Trainers_Projects WHERE Project_Title=[Forms]![Resourcing].[Cmb_Project_Title] ORDER BY [Trainer_Name];
The combo is on a form called Resourcing and the idea is that once someone picks a Training_Type then only courses matching that type are available. (That bit works) Once they select a Project_Title then only Trainer_Names that can deliver that project are available. (This bit doesn't)
I've attached a basic model of the db that you can look at.
Cheers