I have a SearchForm. One button to open AddForm. After add a record and
close AddForm, I cannot use SearchForm to locate the newly added record
until I close and re-open SearchForm.

Same is true when Delete.

On the SearchForm, I have a Delete button to delete a record. Combo Box
search box on SearchForm still can see #Deleted until I close SearchForm and
re-open to see #Delete is gone.

Is there a way to refresh data without close and re-open SearchForm?

Thanks.

You need to Requery the RecordSet to remove the #Deleted messages and pick up
any new records.

Song Su wrote:
>I have a SearchForm. One button to open AddForm. After add a record and
>close AddForm, I cannot use SearchForm to locate the newly added record
>until I close and re-open SearchForm.
>
>Same is true when Delete.
>
>On the SearchForm, I have a Delete button to delete a record. Combo Box
>search box on SearchForm still can see #Deleted until I close SearchForm and
>re-open to see #Delete is gone.
>
>Is there a way to refresh data without close and re-open SearchForm?
>
>Thanks.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200706/1