Copying multiple fields from one form to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

barrynichols@gmail.com - 19 Dec 2007 11:58 GMT

I have two forms, FormA and FormB, based on table A and B.

Both tables underlying the forms have different autonumbers as the
primary key.

Essentially, what I need to do is build a macro that :

Copies the contents Field1 and Field2 from the current record in Form
A,
Creates a new record in Form B, then
Pastes the contents of Field1 and Field2 from FormA into FormB

Any help gratefully appreciated

Reply to this Message

Jeff Boyce - 19 Dec 2007 13:22 GMT

You've described a "how". Now, "why"?

If you are intending to copy data from FormA (based on TableA) to FormB
(based on TableB), you are trying to copy data from TableA to TableB. Why?

In a well-normalized relational database design, it is rarely necessary to
have two tables holding the same data.

If you'll describe a bit more about what you trying to accomplish by having
two copies of the same data, the folks here in the newsgroups may be able to
offer alternate approaches.

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> I have two forms, FormA and FormB, based on table A and B.
>
[quoted text clipped - 9 lines]
>
> Any help gratefully appreciated

Reply to this Message

MuzicK622@yahoo.com - 19 Dec 2007 19:58 GMT

On Dec 19, 7:22 am, "Jeff Boyce" <JeffBoyce...@msn.com-
DISCARD_HYPHEN_TO_END> wrote:

> You've described a "how". Now, "why"?
>
[quoted text clipped - 36 lines]
>
> - Show quoted text -

Jeff, I am looking for the same answer! I have a form and table for
one group of people called "Evaluators" and another table and form
called "Sign Language Interpreters." I am using this for Event
Management purposes (meaning different departments handle different
sections of my database) and am needing to keep my data separate for
assignments, confirmation letters, badges, check requisitions, etc
that I have as written reports. However, I have a command button off
of the Evaluator form that says "Add as SL Interpreter." I would like
all of the name and address information as well as account numbers to
duplicate when I click my button. If I were the only one in the
database, I would simply use subforms, but at the request of other
areas, it needs to be separate. :(

Reply to this Message

MuzicK622@yahoo.com - 19 Dec 2007 20:36 GMT

On Dec 19, 1:58 pm, MuzicK...@yahoo.com wrote:

> On Dec 19, 7:22 am, "Jeff Boyce" <JeffBoyce...@msn.com-
>
[quoted text clipped - 54 lines]
>
> - Show quoted text -

Woohoo! I found the answer for my form and possibly for you too!
On the form "evaluators", I have a button that says "Add as SL
Interpreter"
In the code for this command button I added the following line for
each field name I needed to duplicate:
Forms![Sign Language Interpreters]![LastName] = Me![LastName]

To get this to work you need to make sure that both forms are open.
Otherwise you will get an error. Best case scenario, you should never
have to duplicate information (and you really shouldn't!!), but this
can work for those of us who are really Admin. Assistants and not
programmers! :)

Reply to this Message

Jeff Boyce - 20 Dec 2007 12:33 GMT

While you have found a way to do this, have you also found a way to "ripple"
any changes you need to make?

For example, when you first put in someone's name, you misspelled it. Since
you've duplicated it, now you have to 1) find it everywhere you've
duplicated it to and 2) update it.

Another example ... people move. If you duplicate their address, ...

The approach you found is akin to what happens in Excel ... it notices that
you are using the same "name" and offers to duplicate it for you. And this
has the same problem as above ... no "ripples" unless you manually take care
of changes.

Good luck!

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> On Dec 19, 1:58 pm, MuzicK...@yahoo.com wrote:
> > On Dec 19, 7:22 am, "Jeff Boyce" <JeffBoyce...@msn.com-
[quoted text clipped - 68 lines]
> can work for those of us who are really Admin. Assistants and not
> programmers! :)

Reply to this Message

MuzicK622@yahoo.com - 20 Dec 2007 14:10 GMT

> While you have found a way to do this, have you also found a way to "ripple"
> any changes you need to make?
[quoted text clipped - 105 lines]
>
> - Show quoted text -

No, I haven't figured out how to fix that yet. Thank goodness that for
now we're dealing with so few names and those that I do have to
duplicate only matter for one year. We can manage manually fixing them
for now. If anyone does have a solution for this, I would like to know
about it. :)

Reply to this Message

Jeff Boyce - 21 Dec 2007 12:35 GMT

The solution is to not structure your data that way. Re-read my earlier
responses...

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> > While you have found a way to do this, have you also found a way to "ripple"
> > any changes you need to make?
[quoted text clipped - 22 lines]
> >
> > <MuzicK...@yahoo.com> wrote in message

news:3c2db860-eb10-45d6-b855-dc1c5cba38a3@b40g2000prf.googlegroups.com...

> > > On Dec 19, 1:58 pm, MuzicK...@yahoo.com wrote:
> > > > On Dec 19, 7:22 am, "Jeff Boyce" <JeffBoyce...@msn.com-
[quoted text clipped - 82 lines]
> for now. If anyone does have a solution for this, I would like to know
> about it. :)

Reply to this Message