I have a form with a subform. It is a purchasing main form with the line items in the subform. I use a macro to move the cursor to the subform and then into the product id field. My next macro will paste information into that line item from another table. At the end of the macro I ask it to move to a new record and go to the product id field. The problem is that I cannot get it to move to a new record. I have used go to new record, go to next record. Does not work. I am wondering if the form does not see the information that has been pasted into the original line item so it thinks it is in the new or next record. I am a newbie and pretty lost at what to try next. If the cursor does not move, the next item that is placed into the purchase order just pastes over the original information.

Any help is appreciated!!