form problems

K

kdp

I have several tables that have a common ID Number, but
additional other information in them. When I create the
forms to put input this information, I would like the ID
number to automatically be inserted into each of the
additional tables/forms. I am able to get it to follow
from form to form, but not actually input it in the
tables. How can I get it to copy the current ID number
into the next form and table I go to?
 
G

Graham R Seach

You'll have to have code to do it for you:
Forms!frmMyForm1!txtID = Me!txtID
Forms!frmMyForm2!txtID = Me!txtID

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 

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

Access Form Issue 1
Employee Time card form 2
Moving Data From One Form To Another 1
Duplicate Records 1
Setting DefaultValue 1
Time Calculations in forms 2
Finding RecordID after Insert Into 2
Autofill a new Record in a 2nd form from a different form 1

Top