Delete records in form based on field

alexmb1

Registered User.
Local time
Today, 05:02
Joined
Jun 15, 2009
Messages
41
i am currently working on a form where i have a new employee arriving that will be staying in a departing employees house. in the form i have an employee that is going to arrive and several bits of info, including his permanent address (to be assigned by me). when the employee arrives there normally someone who had just lived in the house they are moving into and are still listed in the database as living at that permanent address. i am using a macro i call "movedIn" that sets that value of the new employees "proposed assignment" to their new permanent address. I would like to find a way to delete the old tenents permanent address without deleting the record completly so i can still have some of a housing history. i have a departure date for every employee and i am thinking that a code that finds the employee with the address in question AND has a departure date that is >Date()-1 will be able to seek this old tenant out and delete their permanent address. however, i am having trouble writing this all out. maybe someone is interested in helping me???

thanks
 
Sounds like all you need to do is design an Update Query to delete (set to "") the data that you don't want to retain.
 

Users who are viewing this thread

Back
Top Bottom