I have a database with 2 layouts: "Tasks" and "Done". Layout "Task" contains one field called "task" which contains all the various tasks I should perform.

Layout "Done" has the tasks which have been performed on any given date.

The question: Is it possible to generate a new record in layout "Done" by clicking on a record in layout "Tasks"?

The new record would contain the task and the date on which it was performed.

So you have layouts based on different tables? Why not just have a field that you can set to the status you want, e.g. new, in progress, done, etc.? What is the point of the "Done" table, are you trying to track the history of the task?

Sorry for the late reply------------ actually what I want to do (after thinking about this again) is to save myself from clicking on a button to run a script. Instead I wish for a way by which something could be triggered by clicking on a field. I seem to remeber that Access has this feature: on click.

Thanks for the reply