Just a note... I put an ElseIF into the macro that made the fields null.

I clicked the ShipSameAsBilling and it filled in the ShipTo controls as you showed, but then I went into the ShipToAddress control and changed the address... once the record was saved it recorded the different address in the table just fine.

Loving these lessons, best money I've spent this year Rich!

The struggle is going to be able to remember HOW to use everything I've been learning after remembering that I learned it!