Continuous Form Usage

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

I have a continuous form in an Access 2003 project. I want to lock field1 in
row1 but have field1 remain unlocked in row2

Can I do this and if so how do I distinguish between field1 row1 and field 1
row2

CL
 
AFAIK, you can't. can you explain why you want to? maybe we can come up with
a solution that will support what you're trying to accomplish.

hth
 
My form processes subscriptions. Once a subscription is
entered and activated most (but not all) fields on that record are not to be
change. Most fields should be locked until the subscription lapses. Each
row has a start and end date and if the currecnt date is between those two
dates I want to lock those fields FOR THAT ROW ONLY.

I really can't create a view only form because even though some fields can
not be changed other fields can be cahnged and the form has a complete set
of right-click menus that allow other functions to the records. I just want
to limit which rows the user can mess with.

It is wierd that I can enumerate rows in a listbox but not in a datasheet or
continuous forms.

do I have ANY options
 
You could put code in the form's BeforeUpdate event to prevent changes being
made to records that are current.
 
Back
Top