Conditionally protect fields

[Raddy]

I have a menu which opens forms in either "update" or "add" mode

How can I protect specific fields in the form if "update" is selected?

 

[MStef]

Try wht LOCKED or ENABLED properties (field properties).

 

[Raddy]

Hi
Because I only want to lock certain fields depending on whether the form has been called for update or add. For example, I don't want the 'ID' field to be opne for update if the form is opened in amend mode.

 

[gemma-the-husky]

normally you would use the current event to set these things

maybe something like

id.enabled = "form is in addmode"


-----------
note the enabled and locked values work together to give 4 different edit options.

 

[MStef]

Look at "DemoLockedEnabledA2000.mdb" (attachment, zip).
Form1 (Locked).
Form2 (Enabled).
Look at VBA.

 

[Raddy]

Mstef - thanks for that I will look at it.

Jemma - how would I have accss to that value in the called/open form