Passing criteria to a report from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a "report" form with a listbox that is populated by an "Add" form.
Users can scan numbers into the Add form which populates a listbox on that
form. When the Add form is closed, the main form listbox is updated. When
the user clicks RUN it opens a report with using the criteria from the list
box. Is there a limit to the length of the filter? The users have recently
received "Filter too long" errors when they scanned a lot of numbers in the
listbox. I am using Access 2003/2000 format.

Thanks
LeAnn
 
According to Access specification in Help, a cell in a query is limited to
1024 characters.
 
Back
Top