Parameter prompt when form is open

[Cadburys]

Hi

I have multiple queries based on queries - each builds (with various
parameters from a form) up to the final query which I am using as the source
for a form.

Suddenly the query keeps prompting me for the value even though the form is
open. Even the first query is doing this.

Here is the sql

SELECT [Task List].*, [Forms]![Main]![cmbClient] AS ClientSelect
FROM [Task List]
WHERE ((([Forms]![Main]![cmbClient])=[Client] Or
([Forms]![Main]![cmbClient]) Is Null));

The form called "Main" is open but is not been "seen".

Any help or guidance would be appreciated.

Thanks

 

[Ken Snell]

Is the query being used as the RecordSource for a subform on the Main form?
Or as the RecordSource for the Main form?

 

[Cadburys]

Hi Ken

Thanks for your reply. It seem to come right all by itself (shut down and
restarted...)

Thanks.
--
Cheers

Is the query being used as the RecordSource for a subform on the Main form?
Or as the RecordSource for the Main form?

--

Ken Snell
http://www.accessmvp.com/KDSnell/

Hi

I have multiple queries based on queries - each builds (with various
parameters from a form) up to the final query which I am using as the
source
for a form.

Suddenly the query keeps prompting me for the value even though the form
is
open. Even the first query is doing this.

Here is the sql

SELECT [Task List].*, [Forms]![Main]![cmbClient] AS ClientSelect
FROM [Task List]
WHERE ((([Forms]![Main]![cmbClient])=[Client] Or
([Forms]![Main]![cmbClient]) Is Null));

The form called "Main" is open but is not been "seen".

Any help or guidance would be appreciated.

Thanks

.