Solved my own problem. I had a "me.requery " in the EXIT event of my subform1.

I have an unbound main form with 2 datasheet subforms that are linked together by a field I put on the main form that reflects the value needed to link the 2 subforms. That works perfectly. So on my main form, I have an Auction Board. On subform1 I have a list of Packages on that Auction Board. I select a specific Package in that subform, and the Item contained in the Package are displayed in subform2. My problem is when I select an Item in...

I have a bound subform in datasheet format on an unbound form. I need to loop through each record, perform a calculation, update 3 fields on the record, then loop and get the next one, continuing until all records have been updated. How do I do this?

Thank you,

Kim