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
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
Use the AfterUpdate event of the ComboBox and the syntax in this link: http://www.mvps.org/access/forms/frm0031.htm
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?
If your form is bound to the table/query where the data resides then use the ComboBox wizard and select option #3.
Thanks.
What do you mean by option 3?
Thanks again
When you start using the wizard it should give you 3 options.