Cannot save new records

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.
 
R

Rick B

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.
 
T

Tim Green

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
 
R

Rick B

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.
 
T

Tim Green

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
 
Top