update a main form combo box from subform info

S

scubadiver

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
 
M

Marshall Barton

scubadiver said:
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)?
Click to expand...


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

Parent.combobox.Requery
 
Top