Thanks Luuk for your reply. Have not altered my code yet as per your reply, having been away for Christmas/New year. Hoping to do that shortly and will advise if works OK.

Delboy39

Hi All, have just found and joined this forum. Bit of background - am 74yrs using m/s office pro 2003 self taught. Using access for small club database. I have a command button on a switchboard that I want to append members details to another database and then delete the record from the current database (member leaves club or is deceased). Am using a combo box to select the record to append/delete but am having a problem with vba code. Briefly -...