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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill out name fields if record exists 10
Display new record option upon NotInList event in combobox 2
main form/subform 6
Adding a field to a subquery 1
Same record/Primary key in multiple tables 0
Command Button MainForm to refer to subform button 3
Autofill text boxes 1
Entering data in a field enters the same data in other forms/field 2

Back
Top