Update Combo Box On Main Form From Secondary Form

[darnnnel]

Hi Everyone,

I have a form “FormMain” on which i have a combo box which pulls values from a table. If the combo box does not have the choice the user is looking for, i added a button that opens a form “FormPopAdd” where the user can enter a new record for that combo box (the user must use a command button to save the new record). Once the user clicks the save button on the FormPopAdd form I have a piece of code that refreshes the original form FormMain behind the pop up form so that the new record can be found in the combo box:

If CurrentProject.AllForms("FormMain").IsLoaded Then
Forms("FormMain").Refresh
End If

This works well if the user has not yet made any changes to the record on FormMain, if the user has made changes, once the code runs, the record is saved – I don’t want that. What I need is for the combo box to be updated on FormMain and not the entire record. How is that Done?

I know it’s a little long, but if you can get me any ideas, I would really appreciate it.

Thanks

[Megalog]

Greets Darnnnel,

So instead of refreshing the entire form, you really only need to requery the combo box itself. This wont save your form's active record changes, it will just refresh the combo box's choices. Change what you're using currently, to:

If CurrentProject.AllForms("FormMain").IsLoaded Then
      [Forms]![FormMain]![YourComboBoxName].Requery
End If

That should be all you need.

[darnnnel]

Megalog,

You are a life saver, thanks very much it worked very well.

Leon

[Megalog]

Glad to help! Figuring out which syntax, property, or command to use use can be troubling sometimes, when you've no example to follow from the past.

Have fun!