form problems

  • Thread starter Thread starter kdp
  • Start date Start date
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?
 
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
 
Back
Top