If Me!STATUS_CHANGED = True Then
        Me!Ref.Locked = True
    Else
        Me!Ref.Locked = False
    End If

If Isnull(Me!STATUS_CHANGED) Then
        Me!Ref.Locked = False
    Else
        Me!Ref.Locked = True
    End If

SELECT TEMP_Order.*, [__TEMP_Потребители].Код, [__TEMP_Потребители].Потребитель, 
[__TEMP_PHYSICAL_PERSON].SURNAME, [__TEMP_PHYSICAL_PERSON].PNAME, [__TEMP_PHYSICAL_PERSON].PATRONYMIC, 
[__TEMP_DIRECTIONS_BOOK].DIRECTION, [__TEMP_DIRECTIONS_BOOK].ID_DIRECT
FROM ((__TEMP_Потребители RIGHT JOIN TEMP_Order ON 
[__TEMP_Потребители].Код = TEMP_Order.Потребитель) 
LEFT JOIN __TEMP_PHYSICAL_PERSON ON TEMP_Order.ID_PERS = [__TEMP_PHYSICAL_PERSON].ID_PERS) 
LEFT JOIN __TEMP_DIRECTIONS_BOOK ON TEMP_Order.Наименование = [__TEMP_DIRECTIONS_BOOK].ID_DIRECT
WHERE ((([__TEMP_DIRECTIONS_BOOK].ID_DIRECT)=[forms]![заказ]![ID_DIRECT])) OR ((([forms]![заказ]![ID_DIRECT]) Is Null));