Basically, I have a form (current form).  Once I add/update a certain field, the records of that row of that field is copied to archives.

So I need it to clear certain fields (on the current form and not the archive form) once I update this certain piece of information.

For example, (This is a bike application)

Customer checks out bike 1, once the customer brings the bike back (actual check in date), that row of records will be moved to archives.

i need it to where i can clear certain records once an actual check in date is established.