I use filtered query as record source for my form and it seems that it 
causes a message error that says "The data was added to the database but 
won't be displayed in the form because it doesn't satisfy the criteria in 
the underlying record source" always appears every time I add my entries. 

Query record source:
select * from reservation where quotID in ('MALAY020303','INDIA010103')

But if I use the table (reservation) instead of query, it will run without 
problem in adding entries.

Please let me know if there's a way to use filtered query without having 
problem like the message says.

Thanks

Change your single quotes to double quotes, and try that..  may or may not
help

Later,
bware

-----Original Message-----
From: Doni Fernando [mailto:doni@s...]
Sent: Friday, December 20, 2002 10:41 AM
To: Access
Subject: [access] Filtered Record Source

I use filtered query as record source for my form and it seems that it
causes a message error that says "The data was added to the database but
won't be displayed in the form because it doesn't satisfy the criteria in
the underlying record source" always appears every time I add my entries.

Query record source:
select * from reservation where quotID in ('MALAY020303','INDIA010103')

But if I use the table (reservation) instead of query, it will run without
problem in adding entries.

Please let me know if there's a way to use filtered query without having
problem like the message says.

Thanks