If I enter data into one field, I want it to move the whole row to a new table

[pinklady]

I'm not sure if I can do this in Access or not, but what I have are 2 tables in Access, Ongoing and Closed. I have a lot of columns in each table, the two that are specific to this are Date Opened and Date Closed.

What I want is if I enter a date in the Ongoing table in column Date Closed, that it moves the whole row of information to the Closed table.

Is that possible? Thank you for your help!

[June7]

It's possible but don't recommend it. Just use the DateClosed field to filter records to show only the ongoing.

[pinklady]

Ok. Thanks.