Data Entry into a subform

[APS]

I have a parent form with a single child form. There are four links between
the two forms. Sometimes when I enter data into the form, by cut and paste
from Excel, in the datasheet view, although the data shows on the subform,
when I close the form and then reopen it the data is gone. It is an
intermittent problem. I can reenter the data and it may or may not accept it.
Sometimes only some of the records do not appear.

I can enter the data in the exact same way and sometimes it is accepted and
sometimes it is not. I have tried "repair and compact" to no effect.

I have noticed that I am no longer getting the message "you are modifing xx
records" (not exact wording of the message) when entering multiple records at
one time.

 

[Jacqueline]

Am I reading this correctly: the data you paste in is actually making its way
to the table, but disapering from the current screen?

If that is the case try setting the Cycle setting in properties for the
subform to current record.

Hope this helps.

 

[APS]

It shows on the screen, but if I close the form, it disappears from the
table. I am looking at the properties and I don't see any "Cycle". Which tab
is it located in?

I am working in ACCESS 2003 with ACCESS 2000 format. I have to use this
format so all my clients can use my app.

Thanks for your help.