data not refreshed until close the form

[Song Su]

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.

 

[ruralguy via AccessMonster.com]

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