Is it possible to display two copies of the same form but with different records on the screen at the same time.
If this is possible - Can it be done if the form has a sub form.
I have a problem with duplicate records - not in the normal sense but because (females in particular keep on changing their surname and address and it is difficult to keep track. When I identify that a duplicate account exists I would like tyo be able to call up both forms on screen at the same time and have a check box at the end of each field on both forms. I could then write VBA code to save the checked items and discard the unchecked items. The coding would also need to reassign the sub form entries the primary key of the form that is being retained. Sounds complex but I'm sure it can be done.
Anyone any ideas
If this is possible - Can it be done if the form has a sub form.
I have a problem with duplicate records - not in the normal sense but because (females in particular keep on changing their surname and address and it is difficult to keep track. When I identify that a duplicate account exists I would like tyo be able to call up both forms on screen at the same time and have a check box at the end of each field on both forms. I could then write VBA code to save the checked items and discard the unchecked items. The coding would also need to reassign the sub form entries the primary key of the form that is being retained. Sounds complex but I'm sure it can be done.
Anyone any ideas