record deleted error when using parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

REcord deleted error using parameter que - 08 Nov 2005 08:07 GMT

I have a query that acesses linked tables. When I use a parameter criteria
(Date or Job Number) I get record deleted and the query aborts. If I enter a
date or Job Number the query runs and returns the expected data.

I can't figure the logic on this. Anyone got any adeas how to fix?

Jim

Reply to this Message

Ofer - 08 Nov 2005 10:37 GMT

Can you post the SQL of the query that you use with the parameters?

> I have a query that acesses linked tables. When I use a parameter criteria
> (Date or Job Number) I get record deleted and the query aborts. If I enter a
[quoted text clipped - 3 lines]
>
> Jim

Reply to this Message