ListBox Requery and Change in QueryDef

[grnegsndhm]

Hey,

Okay. so I changed the query def of a query tied to a list box on my current form. When I attempt to requery the list it does not refresh with the change in the sql that was made through the query def methods. Only when I close down the form and reopen it does it show the results of the new query.

How can I get the listbox to requery without closing the form.

 

[grnegsndhm]

Well I did it myself. I just changed the listbox to a value list and purged and rewrote the list box with the new query data. If anyone has another way let all know.

 

[WayneRyan]

g,

Don't know why, but when Access opens a form (and sees its RecordSource),
they are "married".

If you change the underlying query:

Me.RecordSource = "SomeQuery"

Then you have to do a Me.ReQuery and MAKE it look at the new query.

Wayne