Requery for combo box with data fields

[Brenda morris via AccessMonster.com]

I have a form with a combo box that lists applicants names. If you enter
an applicant not in the box a msg box pops up to add the applicant. The
add applicant form opens and you can update the applicants name address,
etc. When this form closes, the combo box is repopulated with a requery to
add the new applicants name, but, the query fields on the form will not
update. I have tried requery of the key field, requery in after update
field - all to no avail. Can someone please assist.

 

[Michel Walsh]

Hi,


To "requery" the list, try:

Me.Combobox.RowSource = Me.Combobox.RowSource


Note that the NotInList event Response argument can also forces Access to do
the requery for you, as illustrated in John Viescas' book (Inside Out Access
2003, pp 863-867)


Hoping it may help,
Vanderghast, Access MVP