If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Parameter prompt when form is open
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 -- Cheers |
#2
|
|||
|
|||
Parameter prompt when form is open
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" wrote in message ... 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 -- Cheers |
#3
|
|||
|
|||
Parameter prompt when form is open
Hi Ken
Thanks for your reply. It seem to come right all by itself (shut down and restarted...) Thanks. -- Cheers "Ken Snell" wrote: 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" wrote in message ... 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 -- Cheers . |
Thread Tools | |
Display Modes | |
|
|