Refresh Combo Box

[Guest]

I am using a combobox, cboGroupA, on a form, frmAddEvent, to list possible
groups that students would attend in a morning session of class. My problem
is that I may not have all the possible groups listed in the drop menu.

If I have an Add Group Button to open the add a the Add Group Menu, the new
group won't appear on the already open frmAddEvent unless I close the form
and re-open it.

Is there a way to have a combobox requery its table every time you open it
to select a choice?

 

[Roger Carlson]

I would add code to the Add Group Button to requery the combobox after it
has added the new group. Something like:

Me.cboGroupA.Requery

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

On the OnClick event of the combo you can write

Me.ComboName.Requery