Update Combo Box on Main form when record added to another form

[janerussel]

I have a utility form which is a modal popup form opened by a button on my main form. The user can update job titles, job descriptions, etc. by clicking a button on this popup form (these buttons open small popup forms based on individual tables) When a new record is added to one these categories on the pop up forms, the user saves and closes the utitlity form.

On the main form there are combo boxes that are based on the tables described above (job title, job description, etc.) I want these combo boxes to refresh after the user has added a new record using the utility form.

As it is now, the user ads a new job description using the utility pop up form, saves and closes, then goes to the combo box on the main form and the new record is not there.

I know me.requery should work on the combo box, but it is not.

 

[Remou]

You can requery the combo from the utility form:

[tt]Forms![Main Form Name].[Combo Name].Requery[/tt]