going to a new recored on a subform form a different form

I

iridium

I have 3 froms Form A, Form B and Form C

Form B is a sub form of From A. I would like to copy the contents of
From C to Form B. I was able to copy this but I would like to make it
Click to expand...
so when I press the copy button it first goes to a new record on From B
and then copy the contents of it. Is there a way to do this?
Currently it just copies on top of the first record on Form B.

Thanks for the help

Regards,
 
J

John Vinson

I have 3 froms Form A, Form B and Form C

Form B is a sub form of From A. I would like to copy the contents of
Click to expand...

Form C doesn't contain anything, any more than my office windowpane
"contains" the Owyhee Mountain range. The Form is JUST A WINDOW onto
the table.

More critically - it sounds like you are trying to take data from the
table to which Form C is bound, and store it redundantly in the table
to which Form B is bound. This is almost surely a Bad Idea.

What are the Recordsources of these three forms? How are these tables
related? Are you in fact trying to copy an entire record from one
table into another table, and if so, why?
I was able to copy this but I would like to make it
so when I press the copy button it first goes to a new record on From B
and then copy the contents of it. Is there a way to do this?
Currently it just copies on top of the first record on Form B.
Click to expand...

Since you're actually copying data from one TABLE into another TABLE
(rather than from form to form), an Append query would be appropriate
- *if* (as noted above) you want to do this operation at all!!

John W. Vinson[MVP]
 
I

iridium

John thanks for the quick replay.

I have a customer table, which has all my customer information. I also
have another table named Contacts, which is linked to the customer
table. So one customer can have many contacts.

I also have a table for our international reps.

When we sell a system I would like to add the contact information of
our reps to that system so when some one is looking for the contact
information for that customer can also see the reps information with
it.

I know there are better ways of doing this but at the end they want me
to transfer the rep data from the rep table to the contact table as
well.

So you are right the data for the reps will also be under contacts. (I
realize that is not a good idea since if you update any data under the
rep table you need to update it again under the contacts as well.)

I made a form that is link to a query which bring the data of the reps.
once the user clicks on the fill button then the values of each control
is copied to the contacts table

What do you suggest would be better way?

Regards

Zeki
 
J

John Vinson

What do you suggest would be better way?
Click to expand...

Contacts are people.
Reps are people too.

I'd suggest just one People table with the name, address, etc.
information, and link to it from whatever other table or tables need
that information.

John W. Vinson[MVP]
 
Top