Error saving record on a form

[Jim]

Hi,

I created a form which connects to a table. When I try to
save a record it gives a runtime error '30014', The data
was added to the database but the data won't be displayed
in the form because it doesn't satisfy the criteria in the
underlying record source. Why does this error happen?

Thanks.
-Jim

 

[Van T. Dinh]

Do you have any criteria in the Form's RecordSource?

 

[Jim]

Yes, but I dont think it should be a problem. The SQL
Code is:

SELECT *
FROM Contacts
WHERE Deleted = 0

It just basically shows records for which the
field 'deleted'(bit) is false. Is there another way to
filter the records instead of using record source?

Thanks!

 

[Van T. Dinh]

Have you checked the Filter & FilterOn Properties of the Form?

--
HTH
Van T. Dinh
MVP (Access)