Listbox Updating

[AccessFreak via AccessMonster.com]

Listbox: List3

When you click on a record in List3, the form requeries and the text boxes
are updated with the record information.

Here's the problem:

I change information one of the text boxes and click a button that saves. In
addition, this button is also supposed requery List3. The information is
changed and successfully saved, but I am noticing that because the record row
is still highlighted in List3, it will not update with a refresh.

However, when I select another record in List3 and click "refresh", there is
no issues.

What's the appropriate method to get List3 to update with a refresh? Thanks!

 

[Guest]

You need requery not refresh

-Dorian

 

[AccessFreak via AccessMonster.com]

I misspoke... requery instead of refresh... the rest of the post illustrates
the point. Thanks!

You need requery not refresh

-Dorian

Listbox: List3

[quoted text clipped - 12 lines]

What's the appropriate method to get List3 to update with a refresh? Thanks!