Queries & Combos

[swift]

Hello,

I'm trying to set up a form which has a combo box on it containing Project Names. I want to use the combo box to select the project name then hit a button to run a query which returns results only for that project name.
I have the query which I think is okay but everytime I run the query via the button on the form it returns no results in the query.
Its a brief description of the problem which I've tried to resolve using a 'Dummies' book to no real use. Can anybody help please? Will post more later

Thanks

Swifty

 

[Starman]

Can you post the query you are trying to run?

 

[swift]

ok here it is in SQL

SELECT T_Project.Name, T_Job.Operator, T_Sites.Name, T_Facilities.Name, T_Sections.Name, T_Location.X, T_Drop.Sequence, T_Drop.Number, T_Drop.TimeStamp, T_DropDeflection.E0
FROM T_Sites INNER JOIN ((T_Facilities INNER JOIN T_Sections ON T_Facilities.ID = T_Sections.ID_Facility) INNER JOIN (T_Project INNER JOIN (T_Location INNER JOIN (T_Job INNER JOIN (T_Drop INNER JOIN (T_Channels INNER JOIN T_DropDeflection ON T_Channels.ID = T_DropDeflection.ID_Channel) ON T_Drop.ID = T_DropDeflection.ID_Drop) ON T_Job.ID = T_Channels.ID_Job) ON (T_Job.ID = T_Location.ID_Job) AND (T_Location.ID = T_Drop.ID_Location)) ON T_Project.ID = T_Job.ID_Project) ON T_Sections.ID = T_Location.ID_Section) ON T_Sites.ID = T_Facilities.ID_Site
WHERE (((T_Project.Name)=[Forms]![FORM]![Combo22]) AND ((T_Channels.Number)=0))
ORDER BY T_Project.Name, T_Job.Operator, T_Facilities.Name, T_Sections.Name, T_Location.X, T_Drop.Sequence, T_Drop.Number, T_Channels.Number;

I hope thats what you need - Combo22 is the Combo on the form (called FORM funnily enough).
I can only apologise for the table names etc - I'm working with a database that stores test information which was created by the supplier of the test equipment. When I discovered it was storing details in Access I thought 'I can get exactly what I want out of that!'
Until I discovered the structure of the database that is.

Cheers for replying, and thanks in advance for any help you can give.

Swifty