Lock Previous Record Help!

[Ben]

I have a command button on my form that will copy the previous record
entirely, subforms, etc and create a new record with the copied data. What I
don't know how to do is after the button has copied the previous records, I
want to lock the previous records from being edited. Is that possible? if
so, how? i'm not a code-savvy person.

Thanks

Ben

 

[Jeff Boyce]

Ben

I may be missing something ... I don't understand why you'd need to create a
new record that was a duplicate of a "previous" record.

If you're doing this because most of the fields have the same values, you
might want to take a bit of time to brush up on normalization and relational
database design. It is rarely necessary or appropriate to have a number of
near-duplicate records in a table. Or maybe I just don't understand your
specific situation yet...

Before you push down the path you're on, consider providing a bit more
specific description for the volunteers here.

Also, you mention "the previous record". Access records don't have any
specific sort order unless YOU set the sort order. How are you determining
that a record is "the previous record"?

Regards

Jeff Boyce
Microsoft Office/Access MVP