Prev: Calculating page/report sums using calculated data from subquery
Next: THANKS MARSHALL
From: sk on 21 Apr 2010 16:37
it is set to NONE. I had it working on a different form with the same
setting. I can not figure out what is different between the two forms.

"John Spencer" wrote:

> Is the listbox's MultiSelect property set to SIMPLE. If not, that is your
> problem.
>
>
>
> John Spencer
> Access MVP 2002-2005, 2007-2010
> The Hilltop Institute
> University of Maryland Baltimore County
>
> sk wrote:
> > I'm trying to get a report to load that is based on a criteria which is set
> > according to the value of a listbox on a form. (all in 2007) When I open
> > the report (by clicking on button) Access asks for the parmeter [which is the
> > listbox.value]
> >
> > The report will run fine if I enter the correct value but I don't want it to
> > ask.
> >
> > this is the format of the criteria in the query:
> > [Forms]![frmMain]![lstPRRListing] The listbox does have a value when the
> > report is opened and the form is never closed.
> >
> > Any thoughts on why the query can not see the listbox?
> .
>
From: John Spencer on 22 Apr 2010 09:52
Whoops. NONE is the correct setting.

Could you show us the query that the report is using (View: SQL then copy and
paste)?

Is it possible that you have misspelled the reference to the listbox.
For instance could it be that
[Forms]![frmMain]![lstPRRListing]
should be
[Forms]![frmMain]![lstPRListing]
(note the dropped double R in lstPRRListing).

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

sk wrote:
> it is set to NONE. I had it working on a different form with the same
> setting. I can not figure out what is different between the two forms.
>
> "John Spencer" wrote:
>
>> Is the listbox's MultiSelect property set to SIMPLE. If not, that is your
>> problem.
>>
>>
>>
>> John Spencer
>> Access MVP 2002-2005, 2007-2010
>> The Hilltop Institute
>> University of Maryland Baltimore County
>>
>> sk wrote:
>>> I'm trying to get a report to load that is based on a criteria which is set
>>> according to the value of a listbox on a form. (all in 2007) When I open
>>> the report (by clicking on button) Access asks for the parmeter [which is the
>>> listbox.value]
>>>
>>> The report will run fine if I enter the correct value but I don't want it to
>>> ask.
>>>
>>> this is the format of the criteria in the query:
>>> [Forms]![frmMain]![lstPRRListing] The listbox does have a value when the
>>> report is opened and the form is never closed.
>>>
>>> Any thoughts on why the query can not see the listbox?
>> .
>>
 | 
Pages: 1
Prev: Calculating page/report sums using calculated data from subquery
Next: THANKS MARSHALL