After update field copy the same text to another field

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

Vince

Hi,

Newbie calling any coders...pls assist!!!
I have two tables that I created and made it into one form
with the exact same primary ID in both tables.

When the users enters in the table1.primaryID for one
table I would like to know a code that can tell it upon
update to copy and paste the text into the other
table2.primaryID.



THank you!!!!

You guys are great!

Vince
 
Vince,

You may want to tell us a little more about what you are trying to
accomplish as this doesn't sound like something that you would want to do in
normal practice. If table2 holds child records of table1, you would usually
use a subform which will automatically poplulate that field for you.

Gary Miller
 
Hi Gary,

Yeah I know that would be the norm but the user request
that the FORM to look a certain way which means no sub
form. She want's it to be transparent. The two tables
are one to many relationship.

Please advise?
 
Well, assuming that you want the second form to open with a blank record and
then have the ParentID poked in, you could do this. I am making up form and
field names as they really weren't provided.

Docmd.OpenForm "frmYourChildForm",,,,acFormAdd
Forms!frmYourChildForm!ParentID = Me!FirstFormID

Gary Miller
 
Back
Top