lock & unlock the record in grid (datasheet) mode

S

skk

Hi!

User wants to view all the records at once in grid mode but be able to edit
if he sees the incorrect data. The problem is that he doesn't want to enter
the data accidently. Is there a way to edit the field/record in grid mode
where you have a button to lock or unlock? I know it can be done in form
mode but user want to see all the records in datasheet(grid) mode. Thank
you in advance.
 
J

John Vinson

Hi!

User wants to view all the records at once in grid mode but be able to edit
if he sees the incorrect data. The problem is that he doesn't want to enter
the data accidently. Is there a way to edit the field/record in grid mode
where you have a button to lock or unlock? I know it can be done in form
mode but user want to see all the records in datasheet(grid) mode. Thank
you in advance.
Click to expand...

Use a Continuous form. It can be made to look like a datasheet, but
supports additional flexibility such as you describe.

John W. Vinson[MVP]
 
S

skk

Thanks a lot John.

John Vinson said:
Use a Continuous form. It can be made to look like a datasheet, but
supports additional flexibility such as you describe.

John W. Vinson[MVP]
Click to expand...
 
Top