update a main form combo box from subform info

[Guest]

In my main form I have a subform to hold job titles. In the main form I have
a combo-box that uses the titles from the subform as a criteria for a query
to produce a job description report.

Once I have entered a new job title, how do I automatically update the combo
box to include the new job title(s)?

cheers in advance

 

[Marshall Barton]

In my main form I have a subform to hold job titles. In the main form I have
a combo-box that uses the titles from the subform as a criteria for a query
to produce a job description report.

Once I have entered a new job title, how do I automatically update the combo
box to include the new job title(s)?

Requery the combo box in the subform's AfterUpdate event:

Parent.combobox.Requery