Camera Offset Not Changing When I Change Camera Subject

When the Camera Subject is focused on the Humanoid, Camera Offset works just fine, but when I Change the Camera Subject to a part, Camera Offset no longer works. My script:

workspace.CurrentCamera.CameraSubject = workspace.Part
player.Character.Humanoid.CameraOffset = Vector3.new(0,-5,0)

Why is this not working?

Hi! Have you tried changing the CameraType?
Change it from Custom to Scriptable, custom is used by Roblox and can be controlled by the player.
Scriptable is used if you only want scripts to change the camera.
workspace.CurrentCamera.CameraType = Enum.CameraType.Scriptable

That didn’t seem to work, it just locks the camera into place

Be sure you do it before you change the properties of the camera.

This is intended, the camera offset property only works when Camera.CameraSubject is set to the characters humanoid.

Is there anything else that I could do to simulate offset?

I know this would probably be inefficient, but maybe changing the CFrame of the character offset to the characters/part position?

On RenderStepped

Thanks guys for helping me, I solved my problem by just adding another part for the camera!