Error saving record on a form

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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!
 
Have you checked the Filter & FilterOn Properties of the Form?

--
HTH
Van T. Dinh
MVP (Access)
 
Back
Top