dim db as dao.database
dim rs as dao.recordset
set rs=db.openrecordset(YourShippingTableName,dbopenSn apshot)
rs.findlast "CustomerID=" & me.CustomerID
if rs.eof then
msgbox "Error, no record found for customer")
'take appropriuate action
Me.sLastAddress = rs!Address
The forgoing assumes the "last" record for the customer is the correct one. some other criteria might be involved, depending on the order of the underlying table.
A snapshot is merely a copy of the recordset. Snapshots cannot be modified; dynasets (dbopendynaset) can be.
The foregoing, at least, should get you started in the right direction.
Get the job done right, rather than do the right job.
Do it fast or do it right. Teach a man a fish . . .
If it ain't broke, don't fix it.
Note that I don't open posted databases, period.