Copy one record to another.

  • Thread starter Thread starter William via AccessMonster.com
  • Start date Start date
W

William via AccessMonster.com

I need help trying to find out how to make one of my feilds pull the result
from another feild on the same form. However both feilds are in different
tables.
 
I need help trying to find out how to make one of my feilds pull the result
from another feild on the same form. However both feilds are in different
tables.
Click to expand...

Could you explain why, and what you're trying to accomplish? Storing
data redundantly in two tables is generally a bad idea!

To do it, use some appropriate event (the AfterUpdate event of the
source control) to "push" the value into the field.


John W. Vinson[MVP]
 
I am working on a database where computers are checked in and out by
students for repairs. On my check-in form I have the user scan the label
on their computer that calls up all of their information based on 2 tables
and a query. The check-in form that is based off the check in table needs
to keep a record of the student IDs so I have an history of what the
students are destroying, but I am unsure how to make it input the current
student id for that laptops. I have a bound control to the table called
user id and I can see the user id from the lookup but I don’t know how to
get that to input into my bounded control.
 
Back
Top