Lock a field !

[Anh_Tran]

Dear All,

Can we lock a field depends on other field.

Example If Field A is nul then lock field B ( can enter data).

If Field A is not nul then we can enter data in field B .

I don't want to use passord.

Is there a way?

Thanks

[LiveOak]

Attach a script to the field and take it out of the tab order. The script would look like:

If(IsEmpty(Field A))

Goto Field []

else

Goto Field [Field B]

End If

You can also use validation. Set the validation for Field B to: NotIsEmpty(Field A)

-bd

[Anh_Tran]

I would like to know that at the beginning ..a field is empty ( no data) then I enter data first time ...when I leave that field, that field is protected or a message pop-up to ask if edit the data or not? ...

is there a function isclicked (field) like in access to check the field? but enter data and make that field as a button with script seems like not possible?

Anyone has any idea?

Thanks

[Anh_Tran]

I solved the problem already since I followed Liveoak says

Thanks