how to refresh a form's query

[Toeying]

Hello All,
I am working with a form which has a combobox with which I display all the addresses on my system. The user is able to search thru to find an address.
If the address does not exist, the msgbox pops up asking if the user want to add the new address. If the user says yes the a new form opens for the user to add the address.
My problem now is after adding the new address and saving and closing the add new address form, the main address display for still doesnt recognise the new address unless in is closed and reloaded.
I have tried to use: Forms![Mail form name].requery
but it doesnt work. What can else I do? thanks

 

[statsman]

The simple response is...you have answered your own question.
Close the main form, then re-open it.

Create a macro to run from your address form. It contains:
Close - Form - address form
Close - Form - main form
OpenForm - main form
Place a command button on your address form to run the macro.

 

[Toeying]

yeah thanks. did some thing like that already, but didn't use a macro. thanks a million