Yes - I want duplicate records

  • Thread starter Thread starter dkschoonover
  • Start date Start date
D

dkschoonover

do to space limitations, I had to create a popup which enters additional data
into the main table one of my forms references. However, when I use the
Duplicate command, it only duplicates the data visible on the main screen -
and does not duplicate the added information which has been saved to the
record. How can I fix this?
 
We aren't there. We don't know how you've set up the table structure or the
forms. We don't know what the popup form references.

By the way, if your "subject" is to be taken literally, you may be trying to
force Access to do what a spreadsheet would do... A well-normalized Access
database does NOT need duplicate records.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
OKay - let me try to better explain. I am keeping record of custom ordered
conference calls. I have one table which contains all of the call details -
including special requests (recording, attendance lists etc). All of the
call details are contained on one form, but the special requests are entered
through a pop-up form.

I have one user that holds bi-weekly calls with the same parameters -
however due to size, it may be assigned different conference login's from the
provider. Rather than re-enter these calls manually, I use the "duplicate"
function in VB. When I use the VBA Duplicate script (as outlined in one of
the previous posts), it only duplicates the information displayed on the
form, but not the popup (which stores the records in the same table as the
call detail. Is there a way to tell it to look at the table and duplicate
the entire record, not just the form-visible data?

Darryl
 
You are asking a "how" question before providing enough information about
the "what".

It all starts with the data. Please describe the table structure you are
using.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top