After update field copy the same text to another field

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
 
G

Gary Miller

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
 
V

Vince

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?
 
G

Gary Miller

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INSERT / UPDATE Query in same operation 2
Update table field by content in another field in the same table 2
copy text box value from current form to "Next" form 1
Show names in Lookup Field instead of IDs? 3
Two Form Fields Reference The Same Table Field 3
Copy text in a field from one to another. 1
Update a field from 1 through 10 6
Access Access 2010 import/append data into table w/o overwriting existing records 0

Top