Editing

  • Thread starter Thread starter dale
  • Start date Start date
D

dale

I have a form that shows one record from a table at a time. I want to
know if I can turn off and on the editing of these rows. Some rows I
want to allow the user to edit others I do not. Any help is appreciated.
 
You can use an if statement in the "current" event to set the locked value
for each control based on another field.

In other words, if you have a checkbox on your records called "complete" or
"locked" you could test to see if this was checked. If it was, then you
would set the controls locked value to true.

Since you don't tell us how you'd determine which rows could be editted and
which can't, it is difficult to give you a detailed answer here.


Rick B
 
Rick,

It will be based on an id column. If the id is less than a certain value
it will be non-editable otherwise the user can edit them. The table has
3 fields. The id, and abbreviation and a text column. If I understand
you correctly I can set the field to locked for the abbreviation and the
text column based on the id column in the current event.

Dale
 
You got it!

something like...


If ID < 1000 Then
Me!abbreviation.locked = true
Me!textcolumn.locked = true
Else
Me!abbreviation.locked = false
Me!textcolumn.locked = false
End If



Rick B
 
Thanks

Rick said:
You got it!

something like...


If ID < 1000 Then
Me!abbreviation.locked = true
Me!textcolumn.locked = true
Else
Me!abbreviation.locked = false
Me!textcolumn.locked = false
End If



Rick B
Click to expand...
 
Back
Top