Recent content by CynthiaFL717

Here it is

it is over 3.5mb it won't let me upload it, can I send it by email?

This is the code i'm using: 'On Error GoTo Err_Handler 'Purpose: Duplicate the main form record and related records in the subform. Dim strSql As String 'SQL statement. Dim lngID As Long 'Primary key value of the new record. 'Save any edits first If...

I did try using Allen's code, but I get error 3022 - the changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or...

Hello, I am a first timer in this forum and wanted to get help on how to duplicate records in SubForm, i have created a form (transmittal) with a subform that contains all items listed: Master Field : Transmittal No Child Fields: IDTransmittalNumber there is a button that allows me...