Copy and paste entire form content as a new record

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

Hi,

After my user finds a record in which I display on a form
does anyone know a code that I can program a button so
that certain fields that are found in the current record
will be copied into a new record on the same table?

Some type of copy and insert method? I am a total flop
with VB!

Thanks!
 
Hi Gary,

WOW thanks for your generous assistance!

All I want to do is omit more data entry. If the record
is found in 01TranscriptOrders than simply copy ALL fields
EXCEPT TranscriptOrderNumber, TranscriptFinalizationDate,
NumberofCopies for these will be entered MANUALLY.

I include the fields and data types for your review.

Table Name: 01TranscriptOrders
Form Name: 01TranscriptOrders

Form Fields: Data Type:

TranscriptOrderNumber Text
CaseFileNumber Memo
CourtDate Date/Time
CourtTime Text
SurnameofDefendant Text
FirstnameofDefendant Text
CompanyName Text
Charge Text
CRTM Text
SurnameofClerkMonitor Text
FirstnameofClerkMonitor Text
TranscriptFinalizationDate Date/Time
Notes Text
CourtLocation Text
Section Text
Statute Text
NumberofCopies Number
SurnameofPreparedBy Text
FirstnameofPreparedBy Text
TOID (OrderTable PKey) AutoNumber
 
Hi Gary,

Thanks for your generous assistance!
I need all the following fields copied as a new record
EXCEPT: TranscriptOrderNumber, NumberofCopies,
TranscriptFinalizationDate for these will be entered in
manually. Thanks again!!!

Table Name: 01TranscriptOrders
Form Name: 01TranscriptOrders

Form Fields: Data Type:
TranscriptOrderNumber Text
CaseFileNumber Memo
CourtDate Date/Time
CourtTime Text
SurnameofDefendant Text
FirstnameofDefendant Text
CompanyName Text
Charge Text
CRTM Text
SurnameofClerkMonitor Text
FirstnameofClerkMonitor Text
TranscriptFinalizationDate Date/Time
Notes Text
CourtLocation Text
Section Text
Statute Text
NumberofCopies Number
SurnameofPreparedBy Text
FirstnameofPreparedBy Text
TOID AutoNumber
-----Original Message-----
 
Back
Top