Autofill of a field

  • Thread starter Thread starter moneyball.wilson
  • Start date Start date
M

moneyball.wilson

Hey,

I have been working on this problem for a whie and finally decided I
needed help. I have a subform that deals with patient visits and one
field asks for weight. I have a another subform that deals with
medications...I need the patient weight from the clinic visits subform
to populate into the weight field for medications after it has been
entered, so that it doesn't need to be entered for each medication.
However, the patient medications is based on a query and I can't figure
out how to the weight field autofill. The subforms are iinked to the
main for through a patient id number Does anyone have any suggestions?
Thanks

B
 
Since you will not be updating the weight field in the medications subform,
the simplest way to achieve this is to make the control source for the weight
field in the medications subform reference the weight field in the visits
subform.
=[Forms]![MyFormName]![SubFormControName]![Weight]

(Not absolutely sure of the syntax. I don't have an environment to test it.)
 
Back
Top