I'm going to try and simplify my problem as best as I can. Hopefully it's clear enough. I have a form that shows a list of items, called "Locations" (just to simplify). Then I have a combo box that has a list of "spare" items to be "installed." The idea is that once the item is installed, it is removed from the combo box list. I have to issue the command "Me.cboInstallPart.Requery." Otherwise, the installed part remains on the list and can be selected again, which I do not want. The problem is that when the "Me.cboInstallPart.Requery" is executed, it also resets the list of locations, so that the current record goes back to "1". It basically seems like every single subform resets. I know this because if I comment out the "Me.cboInstallPart.Requery" command, the locations table stays on the current record, but the combo box still contains the installed part. Just trying to figure out how to do the requery on the combo box without resetting the record position in the locations table. The two tables are not linked together with any child-parent relationship, so I don't know what is going on here. Thanks.