is there is a way to make a record locked

[Nokia N93]

is there is a way to make a record uneditable
Lock it
Something like an archive ,, no one can edit it ??

[weekend00]

in a form or in a table?

in a form, you can do it in current event, when this record get focus, lock everything, and unlock when it lose focus.

[TheShabz]

Not a specific record, AFAIK. If this is a multi-user environment, what I would do is split the database (thus making them linked tables to the user), and having everything set up through forms. This way, they never get access to the tables themselves.

[Nokia N93]

Hi all

i tried to use the code
i made a field in the table with a yes/no status, when i check it , it must lock everything
but i couldn't find the onCurrent Event

CAn you help me with a sample db

[vt800c]

SNIP:i tried to use the code
i made a field in the table with a yes/no status, when i check it , it must lock everything
but i couldn't find the onCurrent Event

The OnCurrent Event is a form-level event

[khalid]

Hi all

i tried to use the code
i made a field in the table with a yes/no status, when i check it , it must lock everything
but i couldn't find the onCurrent Event

CAn you help me with a sample db

Hi, What code you are using to lock the record? if you want to lock/unlock fields on the form when certain condition is true then:

'-------------------
if yourcondition is true then
yourFieldOnTheForm.Locked = true
else
yourFieldOnTheForm.Locked = false
end if
'--------------------

The above can be call on the current event of the form

Best Regards,
Khalid Afridi