Locking records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I require the ability to lock records in a form. For example, we had an
event XXX. The event XXX is complete and everything is processed. Then YYY
event comes up. However, people that register are entered in the middle of
XXX's events. I would like the ability to lock XXX records. So no more
changes could be added to them.

Currently, people don't know exactly what event they are in and then start
changing information.
 
Without some specifics about your underlying data structure, any suggestion
is a guess...

How do you let Access know that event XXX is complete? If you have a field
that contains a Yes/No, or a DateCompleted, you could use that in a query
filter out the event XXX as a choice.

Regards

Jeff Boyce
<Office/Access MVP>
 
The form is simply one overall form with subforms. I currently use the Tab
Option and every TAB is a subform from the master. I don't need to filter
out records. Currently I do have a complete yes/no flag so people looking
know if this record is complete.

My problem is that now that more than a year's worth of data is compiled in
the forms. Our events are very repeatative. So now people are modifying last
years records no realizing they are last years not this years. I would like
to ability to lock last year's records so no modifications are completed at
all. DATA Entry staff use last's years forms for comparisons. This is why
they are looking at the wrong form.
 
Travis

And I still don't have a clear picture of your underlying data
structure...<G>

Forms display data, tables store data.

If I want to prevent folks from adding records to a year-old, already
completed event, I can either not display that old, closed event (filtering
out, using a query), or I can add validation code that lets them do the data
entry, then tells them they can't do that. I prefer the former approach --
not giving them the chance to do something they shouldn't be doing.

(and I still don't understand enough about your data structure to offer
specific ideas...)
 
Back
Top