Hi Reza,

1) Add this code into Init() event of the listbox class/object

This.Tag=SYS(2015)

2) Add this code into Destroy() event of the listbox class/object

IF USED(This.Tag)
   USE IN (This.Tag)
ENDIF

3) Add "INTO CURSOR (This.Tag)" to end of RowSource's value

MartinaJ

PS: I don't test it :-)

>Dear all,
>I have a form with a listbox in it.
>I set it's RowSourceType = 3 ( SQL Statement ) and RowSource = SELECT Admision.AdmCode, Admision.FileNum, SickInfo.SickName, SickInfo.SickFam, SickInfo.SickDad FROM Admision LEFT OUTER JOIN SickInfo ON Admision.FileNum = SickInfo.FileNum WHERE &FilterStr
>But each time that I change FilterStr based on user selection, and run thisform.list1.requery , a browse window shows. It don’t occur when I run my form for first time, but when I issue requery command, browse window come on my form. Why?