Criteria not working

B

Brendon

I had a query in Access 97, that had a field ID_ORD with critera

[Forms]![Open Picked Orders]![ID_ORD]

If the order number was on the form, the query found it.

I upgraded to Access 2003 and this criteria no longer works. If I type a
specific order into criteria instead of using the forms staement, it works.
No error message, the query simply returns no data. Nothing else has changed.

Any clues?
 
K

Ken Snell [MVP]

ACCESS 2003 works the same way as 97 in reading form controls.... so perhaps
something else has changed in the query or form?
 
B

Brendon

Not unless it happened in the convert process. I still have the 97 version
ACCESS 2003 works the same way as 97 in reading form controls.... so perhaps
something else has changed in the query or form?

--

Ken Snell
<MS ACCESS MVP>


Brendon said:
I had a query in Access 97, that had a field ID_ORD with critera

[Forms]![Open Picked Orders]![ID_ORD]

If the order number was on the form, the query found it.

I upgraded to Access 2003 and this criteria no longer works. If I type a
specific order into criteria instead of using the forms staement, it
works.
No error message, the query simply returns no data. Nothing else has
changed.

Any clues?
Click to expand...
Click to expand...
 
K

Ken Snell [MVP]

What type of data would IR_ORD control on form contain? You may need to
declare the datatype in a PARAMETER clause in the query.

--

Ken Snell
<MS ACCESS MVP>

Brendon said:
Not unless it happened in the convert process. I still have the 97
version
ACCESS 2003 works the same way as 97 in reading form controls.... so
perhaps
something else has changed in the query or form?

--

Ken Snell
<MS ACCESS MVP>


Brendon said:
I had a query in Access 97, that had a field ID_ORD with critera

[Forms]![Open Picked Orders]![ID_ORD]

If the order number was on the form, the query found it.

I upgraded to Access 2003 and this criteria no longer works. If I type
a
specific order into criteria instead of using the forms staement, it
works.
No error message, the query simply returns no data. Nothing else has
changed.

Any clues?
Click to expand...
Click to expand...
Click to expand...
 
Top