Parameter prompt when form is open

  • Thread starter Thread starter Cadburys
  • Start date Start date
C

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
 
Is the query being used as the RecordSource for a subform on the Main form?
Or as the RecordSource for the Main form?
 
Hi Ken

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

Thanks.
--
Cheers


Ken Snell said:
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/


Cadburys said:
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
Click to expand...


.
Click to expand...
 
Back
Top