Search results

You can do it with an append query based on copying the current record (use a reference to the field with the record identifier in the form, eg., Forms!frmName!recordID as criterion for the query) in the same table. Run via VBA with a DoCmd.OpenQuery statement.

I'm new to this forum, but not to Access. I've been developing in Access since 1998, when my then-boss said, "Fix this crappy database for me." Within a year, it had become my primary job focus. Even after all this time, I still learn new skills in Access, VBA, and SQL Server all the time, which...