update a main form combo box from subform info

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scubadiver - 25 Sep 2006 21:10 GMT

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

Reply to this Message

Marshall Barton - 26 Sep 2006 01:21 GMT

>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

Signature

Marsh
MVP [MS Access]

Reply to this Message