How do I create a button on a form that will save the current record, copy some of the fields to a new record, and redisplay the new record in edit mode?
Yes, you can click a record in one table and pop up an Add Record form in another table. Just change the part of the formula which identifies the [_DBID_ of the table]