Limit combo list

[guinness]

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

 

[JHB]

Because the width for first column is 0.
Look at the combox's property "Column Widths".