updating combo box on other form

[Seasider]

I have a form called "projects" on which I have a combo box that lists staff names. User can choose the staff person involved with the project from the list. That part works fine.

Users need to be able to add/delete staff names and want to do that by opening a second form called "frmStaff". I have both an ADD and DELETE command button on frmStaff as well as a combo box "cboStaffName" that is a drop-down list of all staff. I am able to have this combo box update after a change.

The problem is to get the combo box on the first form "projects" to update whenever I add or delete a record from the second form "frmStaff".

I have read countless threads on this forum but have not been able to find a solution. In fact, have confused myself more. Can anyone help?

Thanks.

 

[llkhoutx]

Requery the first combobox (on a form presumably left open) after updating its recordsource on another form.

 

[Seasider]

Re updating combo box

Thank you so much Ilkhoutx. I actually found an earlier thread where you explained this. I set both the first form and the combo boxes on it to be requeried when the 2nd form is closed. Works great.

Appreciate your help and that of others on the forum.

Seasider