Rixon,
Use an & macro to expand the value at that instant. Just change it to &lcValue in the RowSource assignment.
>I want to filter the items in a combo box based on the value of a different combo box. How can this be accomplished as part of the rowsource SELECT statement without making the variable lcvalue public?
>
>GOTFOCUS METHOD of Combo2
>
>local lcvalue
>lcvalue=This.Parent.Combo1.value
>
>***Since lcValue is local, the filter in the following rowsource will produce an error message once this method is completed.
>
>this.rowsource="sele prefix,imprint2,publisher from publishe into cursor cpublisher1 having publishe.prefix=lcvalue"