Requerying/refreshing a combo box

[mbath20110]

have a form with a combo box which looks to a table to get its list.

the user drops down the combo box, selects their criteria then clicks 'Find'. My code behind the 'Find' button sets the form's visible property to 'False' then opens another form in which the data is limited to what the user selected on the first form.

Here's my sticking point. When my user deletes a record from this second form, upon closing they are returned to the original search form. However, still sitting in the combo box is the data from the record which they just deleted.

Of course if they click 'Find' again they'll be brought to an empty from which does verify that the record was indeed just deleted but I sure would like to be able to somehow someway refresh/requery my search form such that the data they just deleted does not show in the combo box.

thanks much

 

[charityg]

Form Unload event of your form that displays the information use

forms!yoursearchform!yourcombobox.requery

 

[mbath20110]

?

so I'm clear. is that, requery the combo box in the Unload event of the second form (which is my results form)?

 

[charityg]

yes.

 

[mbath20110]

thanks!!!

your solution worked like a charm ...

thanks ...

 

[charityg]

GREAT!!

Glad it worked for you.

~Charity