Well that will be truly a nightmare when it comes to
maintaining a few months after completion <smile>
But to answer you question...
I do not understand these parts of your Query...
where p.[Forms]![FormCombo]![Combo0]![List]!
[ListIndex] = yes
where p.[Forms]![FormCombo]![Combo0] = yes
This value does not seem to be an integral part of the
query and further ( yes ) is probably being viewed as
a variable and could be the reason the query prompts
for a parameter.
Try changing these lines to something generic such
as...
where tbl.fieldname = 'Yes'
pick a table field that can have a string value. It
does not make a difference if the query actually
returns anything since what you are intially trying to
determine is what is causing the prompt for the
parameter --- once that is determined then you can
work on fixing the logic.
--- itssmily <[EMAIL PROTECTED]> wrote:
> I have a databse in Access and I have a form that
> has a combo box. I need to access the value that
> user selects from combo box and use it in a query
> like:
>
> SELECT t2.[Que$tor version name], qv.Date,
> ([t2].[version]/[t1].[version7]*100) AS ICX_Value
> FROM [SELECT q.[Que$tor version name], sum(q.[cost])
> as [version7] FROM [Project info Tbl] as p
> INNER JOIN [QUESTOR Run tbl] as q ON
> p.[Project ID] = q.[Project ID] where
> p.[Forms]![FormCombo]![Combo0]![List]!
> [ListIndex]=yes and
> (q.[Que$tor version name]="7.3") group by
> q.[Que$tor version name]]. AS t1,
> [SELECT q.[Que$tor version name],
> sum(q.[cost]) as [version]
> FROM [Project info Tbl] as p INNER JOIN
> [QUESTOR Run tbl] as q ON
> p.[Project ID] = q.[Project ID] where
> p.[Forms]![FormCombo]![Combo0] = yes
> group by q.[Que$tor version name]]. AS t2
> INNER JOIN [QUESTOR Version Information tbl] AS qv
> ON t2.[Que$tor version name] =
> qv.[QUE$TOR Version Name];
>
____________________________________________________________________________________
Get the Yahoo! toolbar and be alerted to new email wherever you're surfing.
http://new.toolbar.yahoo.com/toolbar/features/mail/index.php
