I am an administrative assistant. I use an Access database to track incoming and outgoing calls. (Incoming Calls is one table/form, Outgoing Calls is another.) I want to set it up so that, when I return a call, I can duplicate the incoming call form into the outgoing call form. What I'd really like to do is set it up so that double-clicking the phone number in the incoming call form creates a new record in the outgoing call forms with the name, contact information, and "regarding" fields automatically copied. I'm fairly new to using macros and everything, so might need to talk to me like I'm a moron. But I catch on quick. (Not all Outgoing calls will be in response to incoming calls, so simply having all new outgoing call forms reference the incoming calls table won't work...) Sorry if I sound like a novice. I used to be extremely proficient in Access, but that was back in 2004-2008. Things have changed a bit, and I've grown rusty.
Thanks for any help!