Adodc appears on form dimmed??

[MickJ]

I've put an Adodc control on my form (I have two others working perfectly) when I run the project the control appears dimmed and doesn't work. The other Adodc controls I have are using Provider=Microsoft.Jet.OLEDB.4.0 connected to a table and PROVIDER=MSDataShape;Data PROVIDER connected to an SQL. The new one I need to be Provider=Microsoft.Jet.OLEDB.4.0 connected to the same database but using a query. I can't seem to get it to work no matter how I connect it. What am I doing wrong this time I'd appreciate any help you can offer
Thanks
Mick

 

[DonMc67]

check your recordsource, make sure all the field names are correct

 

[MickJ]

Thanks for the reply. This problem occurs even if I copy and paste the Adodc control, doesn't seem to matter which connection I use it always appears dimmed.