Linda
I suppose one approach to this would be to have the form "check" to see what
the date was on the record ... this would require a field in the table to
hold something like a DateCreated. You could have this default to Date() so
that new records would get this date stamp.
Or if the sequence of new records might be important, use Now() to get date
AND time.
So, as a generic approach, if your form checked the DateCreated date on each
record and, if it found the date was before today, would lock the the
controls. You'd need code to cycle through the controls on the form, and if
the control was a textbox, a combobox, a listbox, a checkbox, or an option
group (and any others that might "hold" data), then you'd set the Locked
property to Yes.
Regards
Jeff Boyce
Microsoft Office/Access MVP