Is there a way to copy all the fields from a sub form using a For Each or for next statement.
I had to do this about 40 times. >>>
Forms!frmAddress.frmTopOut!QtyMbTub = Forms!frmMain.frmFixtureSchedule!QtyMbTub
Duplicate Record Error
Thanks for responding. The duplicate record error message doesnt appear until i move to another record. So I dont know where to put the code to try to identifiy there ERR number.
If you index a field in a table to Yes(No Duplicates) to prevent , say an address being entered twice, Is there a way to Trap the Error on a Form when it occurs in VBA? What would be the Error Number for the On Error statement?