I created a database on my computer & copied to a co-worker's and it's not working the same on his computer. DoCmd.Close to close the form doesn't work on his machine - although if I run the db from my machine (shared folder), it works fine. Also, I have a field in the main form that references a total on the subform & it's not populated when he runs the db on his machine - it works fine when I run the same db from my machine. Data properties reads =Spendingsubform.Form!SumofAmount On his machine when I do the "build" to recreate that data properties, it works the first time, but when I close the form and go back in, it's gone Very weird!!!! -- Always grateful for help!!