Queries don't work after conversion to MS Access 2000

  • Thread starter Thread starter Nel Kes
  • Start date Start date
N

Nel Kes

Dear all,

I have this problem with the queries that don't seem the
work anymore. In the query I use selecion criteria in
several fields (example Like [Forms]![MAINBOARD Afdrukken
VTW's]![Nummer] ). The values in the field come from a
form that has default values for every field which are *.
In the previous version this worked perfectly but now when
I try to run the report (which runs from the query using
the default values)it comes with popup screens (enter
parameter value) in which the values need to be entered.
If I only use one field in the query with a selection
criteria than it does work. But when the selection
criteria is also filled in another field (or more fields)
than the popup screen shows up.

Thanks in advance for you help and kind regards,
Nel Kes
 
Don't know if this is relevant...

When you converted to Access 2000, did you compile your existing db before
converting? Have you compiled since converting?

Can you post the SQL statement of one of your (now non-working) queries?
 
Back
Top