Prev: Mass Data Entry - Repost
Next: Calculating page/report sums using calculated data from subquery
From: sk on 21 Apr 2010 15:21
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 21 Apr 2010 15:40
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: Mass Data Entry - Repost
Next: Calculating page/report sums using calculated data from subquery