Disable A record and Ensure user is not able to use it on the Form

[WarrenBelz]

Hi @rmaziwis ,

Sorry for the lateness of this reply.

Firstly, I assume this code is on the OnChange property of the drop-down - also the issue here (now that I have my mind around what you are trying to do) is not the checkbox - it is the field name in the table that the checkbox sets to true. I will call it NotShow in the below - just substitute your field name for this.

I also noticed you have said the field name in the drop-down is Accident Name - I may need a bit more clarification on this, however try this code.

If(
   !isBlank(
      LookUp(
         '[rp].[Accident group]',
         Accidentgroup = DataCardValue46.Selected.'Accident Name' && NotShow.Value = true,
         AccidentGroup
      )
   ),
   Notify("You cannot select this item";
   NotificationType.Error);
   Reset(DataCardValue46)
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.