OK thanks, but I have one more question. What code do I use for the button to add the new record to a different table? I tried transfertext but that doesn't work, I have been having problems with this for so long. Do you have any ideas? Thanks for the help.