How do I use information from one form on another

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

okay say I have 2 forms. One form has employee information
such as First and Last name and employee ID number. Then
there is another form with training info like when they
were trained, what they were trained in and such. These
forms are linked in the tables by the employee ID. I need
to know how to make it so that when you open up the
training form and enter in an employee ID number that is
already in the employee information charts it shows the
employee name greyed out beside the number so that you can
see it's the right person. If you are willing to help me
out email me at (e-mail address removed) and I could send you
a roughly done up database that i have so far.
 
okay say I have 2 forms. One form has employee information
such as First and Last name and employee ID number. Then
there is another form with training info like when they
were trained, what they were trained in and such. These
forms are linked in the tables by the employee ID. I need
to know how to make it so that when you open up the
training form and enter in an employee ID number that is
already in the employee information charts it shows the
employee name greyed out beside the number so that you can
see it's the right person.
Click to expand...

Make the second Form a subform of the first one, using the EmployeeID
as the master and child link field; or, use a Combo Box based on the
Employee table on the second form, storing the EmployeeID and
displaying the name.

Note that data IS NOT STORED IN FORMS. The data is in your Tables; the
form is just a tool for editing that data.
If you are willing to help me
out email me at (e-mail address removed) and I could send you
a roughly done up database that i have so far.
Click to expand...

If you're interested in signing a consulting contract, sure. Otherwise
this request is considered rather impolite. We're all unpaid
volunteers here, donating our time to the newsgroup; fixing your
database up for you goes well beyond reasonable expectation.
 
Back
Top