refresh listbox on field update

[Shift838]

I have a listbox that is populated by query and has 2 columns. Is there a way to refresh the listbox immediately after a text field is updated on a form?

my textbox is called txtservers and my list box is called lstservers

 

[PHV]

In the AfterUpdate event procedure of txtservers:
Me!lstservers.RowSource = Me!lstservers.RowSource

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Shift838]

I see where the listbox refreshes, but it does not change the value to what was changed. I can close out the form and open it up and it is correct.

 

[PHV]

And this ?
In the AfterUpdate event procedure of txtservers:
Me.Dirty = False
DoEvents
Me!lstservers.RowSource = Me!lstservers.RowSource

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Shift838]

That did it! Thanks