OK Here goes. I am trying to use macros such that when the user clicks an entry from a list box, the macro willl search for a prexisting record copy the entire record and copy it to another table. Essentialy to select records from one table and enter them in another. Any help woulf be greatly...