Refresh Combo Box by Closing A Form 1

[tyleri]

I have a main form that has a drop-down combo box. If the user doesn't see the person in the list they want to select, I have a button that will open a new form where they can add the new person to the list. The problem is - after closing the New "add person" form, the combo list on the MAIN form needs to be refreshed somehow - It only works for me when I close the form and open it again. Is there a way to close the ADD form and it will refresh the combobox on the mainform??

 

[TrojanRabbit]

Form_<main form>.<combobox>.Refresh

Forms!<main form>!<combobox>.Refresh

One of these ought to work.

 

[EvilCabal]

Hi, requery the combo box on the same button that calls the form. Like this :

Private sub ButtonWhatever_Click()
docmd.openform &quot;YourForm&quot;,,,,,acdialog
ComboBox.requery
End Sub

I hope this helps.

 

[TrojanRabbit]

Oops! It's Requery, not Refresh.

 

[tyleri]

neither of those work

 

[TrojanRabbit]

Put Form_<main form>.<combobox>.Requery in the ADD form's Unload event.

 

[tyleri]

access doesn't like <'s isn't the syntax ['s?

I am putting this command on the ADD form's &quot;close button&quot;.

is there a &quot;docmd.&quot; function?

 

[TrojanRabbit]

I'm actually just using <> to say replace the name. Something like Form_main.Combo0.Requery. You may need to do Forms![main]![Combo0].Requery instead. Not sure.