Cannot save new records

  • Thread starter Thread starter Tim Green
  • Start date Start date
T

Tim Green

Not sure if *this* is the forum for asking this question, but I inherited a
small access programme, which allows the creation of new records, and has
been doing so, up to now.

Now, I can fill out the new record, or several new records, and page back
and forth between them, but when I exit and then re-enter the programme, the
new records are no longer there. They have not been saved.

Updates to *existing* records, however, *are* saved.

Is there a common 'something' to look for when this happens?

Thanks.
 
You say they are not there. Are you sure? Have you actually looked at the
table to see if they are there? Maybe your form is limiting what is
displayed.
 
Rick,

You are correct--they *are* in the table. But they don't show. I looked at
the Filter options, but I'm not sure where to check to see if a filter is,
in fact, in effect. I suspect there must be one, because if I back-date my
computer to a date in 2005, I can add (and see) new records.

How would I check to see why I wouldn't be able to see anything I enter with
a 2006 date? Would that be a filter? Are filters somehow attached to forms,
and therefore changeable?

Tim
 
Look at the query upon which tour forms and or reports are based and see if
there is any criteria stating that records after a certain date should not
be pulled.
 
Rick,

I found it before I read this message, but you were absolutely right: the
form was based on a query, and the query had the first and last dates of
2005 (with a BETWEEN). As soon as I changed those to 2006, presto!

Thanks for your help. :)

Tim
 
Back
Top