hello all, and please help, I have an access program that I am trying to move some data from one form (table) to anther form (table) and both forms are open and I would like to have the VBA code look at the form in the back ground and have it go to a new record. this is what I am trying to use right now but with no luck : DoCmd.GoToRecord , Forms!Product_Usage_Input,acNewRec can any one please tell me what I am doing wrong? thanks for looking