copy & pasting between records is freezing Access

[Flavalab]

I have a database in the Record Collection template and I am copying the
detail in multiple lines in Track number area to the next record and it
copies to the record, BUT in the bottom left corner of Access it has
"Calculating..." and the whole program is stuck like this. I have to go to
Task Wizard and end Access to get out of Access. I can copy and paste one
line with no problems. I had no problem doing with Office 97 and Windows 98
with this file, now I have Office 2000 and XP, is there something I am
missing or a change in program issue??? Please help, I have lots of info to
enter and this is a time saver for duplicates.

 

[Steve Schapel]

Flavalab,

I am not sure whether any version differences apply to your experience
there. But I would certainly avoid trying to enter records using
copy/paste. Access has a built-in keyboard shortcut Ctrl+' which copies
the data to the current control from the field in the previous record.
That may be applicable to your situation. Another approach may be to
but a command button on the form, with code or macro to run an Append
Query, which will add a new record to the table replicating the data in
the applicable fields in the current record.