Do you mean when the user selects a row and hits EDIT+COPY or ctrl+C? Or do you mean when they enter data in a row that is exactly the same as the data in another row? Please explain more what you are wanting and why, and maybe we can help out. Thanks.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
when I copy a record I also copy dependant records in a related table.(I know how to do this). I just want to insert this code on a copy method for the datasheet row
I looked up KeyDown and KeyPress events, but i don't think that'll work for you. How about putting code in the Double-Click event; then when you select a row and then double-click it (on the record selector), the code will fire. Write the code to copy, paste, append, whatever it is you are doing.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.