Update field in Subform

[j2curtis64]

Hi,



I would like to update a field in a subform based on the value in a field that is in the main form (in a combo box).

How would I do that?

Thanks

[RuralGuy]

Use the AfterUpdate event of the ComboBox and the syntax in this link: http://www.mvps.org/access/forms/frm0031.htm

[j2curtis64]

Thanks for taking the time to assist me.

Another question for you....

I want to update other fields in my form based on the value of one field. For example, I would select the name of a person in a combo box then when selecting the particular name the other fields would update based on the person that is chosen.

Does this make sense?

[RuralGuy]

If your form is bound to the table/query where the data resides then use the ComboBox wizard and select option #3.

[j2curtis64]

Thanks.

What do you mean by option 3?

Thanks again

[RuralGuy]

When you start using the wizard it should give you 3 options.