subform question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two forms. One contains all the header information for an evaluation:

Evaluator
Vendor Evaluated
Date of Evaluation
Period of Evaluation
Etc.

The second has the ratings to the evaluation questions

I am trying to link these two tables on the form by using an autonumber
(EvaluationID) in the header form and trying to apply that information in the
subform using the following string in a text box associated with a Evaluation
ID field in the subform.

=Forms![EVALUATION INFO]!EvaluationIDtextbox

My question is: I can get the textbox to display the data I want (the
appropriate auto number). However I can not get the data entry form to input
the data in the appropriate feild in the subform table. What can I do to get
this done?
 
Chris,

Set the MasterLinkFields and ChildLinkFields properties of the subform to
the name of the *field* in the main form RecordSource and subform
RecordSource, respectively. Access will then automatically insert the parent
value into the subform field for you. You needn't display this field in a
subform control, but if you do, set the textbox' ControlSource to the name of
the subform field, rather than a reference to the main form control.

Hope that helps.
Sprinks
 
Back
Top