Hi Alex.  I looked through the PC Resale database up through Expert 22 and can't find where Richard did this with either shipping addresses or credit cards.  This is a real normal thing for me to have various ship addresses to and credit cards for each customer.

---

Reply from Alex Hedley:

Yeah it won't be in the new 2010/2013 courses as that hasn't got to Programming yet.

Looks like it might be Access 303.
Although this is Access 2003, programming has changed much so should all still work, it should be easy enough to follow along even if you haven't done any VBA yet.

You could use the principles of this TIP which shows VBA copying values from one place to another.
Just need to know the ID of the Card or Address you want instead of the Max or Last ID.