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
thanks