Refresh a form after importing

[gschimek]

So I feel like this should be easy but I'm not finding an answer by searching.

I have a form that's using a query as a record source. Normally that query is empty, as it's just linked to a temporary table, so when I open the form, generally I'm on record 1 of 1.

On that form is a button that imports data from a text file. I want to find a way to refresh the data on the form after importing, so that it shows the new records without having to close and reopen the form. So where I was on record 1 of 1 before importing, I want it to show that I'm on record 1 of 25.

Any ideas?

 

[Galaxiom]

Use the Requery method of the form.

 

[gschimek]

Hmm. I could have sworn I'd already tried that. But I tried it again and that did the trick. Thanks.

 

[Galaxiom]

Maybe you did Refresh? That just shows changes to existing records. Requery is required to show new records.