hey everyone,

I thought this would be pretty simple but I am running into some troubles.

I want to replace a null ID in a table with the previous ID in the same table if ID is null.

I have been trying VBA but I can't seem to do it. I can do it fine in Excel but that is way to manual.

Any thoughts to get me going in VBA?