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!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Advanced 5.