Does anyone know how I can allow a data field...

[Robert_Winsloe]

Does anyone know how I can allow a data field (column) to be completed for a new record but also prevent that same field from being editable in an existing record when in update/edit mode?

[RezaRaoofi]

Open the column’s definition and enter this expression in its Editable_if property:

ISBLANK([_THIS])

[Aleksi_Alkio]

The problem with Reza’s formula (sorry Reza) is when the user makes a typo error, he/she can’t do anything. Sometimes it’s okay and sometimes not. How about… NOT(IN([KeyColumn],TableName[KeyColumn])).

[Robert_Winsloe]

Many thanks Aleksi.

Your formula worked perfectly.

In the end I included your formula in an OR statement.

The first option was your formula the second was USEREMAIL()=[email of user].

This then allows the user to edit all fields in their own records but not for others.

[RezaRaoofi]

If you were going to allow each user to edit their own record which I think is a great idea and makes a lot of sense, then that OR will neutralize Aleksi’s formula, because for new records that USEREMAIL()=[email of user] piece by itself will always return TRUE, and it would be enough on its own (assuming the initial value of [email of user] is set to USEREMAIL(), and prefilled for all new records).

[Aleksi_Alkio]

Good point Reza

[Robert_Winsloe]

Very good point!!

Thank you.