>Hello Anyone -
>
>I have a form that uses a view. This view is a list of items. When the user selects the item, I pass the item # to another form (do from detail with item#) The Init of the detail form sees the item # fine - but I can't seem to set the filter of the view. Presently in the init I use thisform.dataenvironment.cursor1.filter = item# = itempassed. I then do a requery of the view - but it never sets the filter.
>
>Any help would be appreciated.
>
>Thanks Mike
Mike,
You could include item# as part of where clause.
create sql view as select .... where ItemNo = ?nItemNum
Add it in DE with NoDataOnload.
In init of form :
lparameters tnItemNumber
nItemNum = tnItemNumber
requery("myView")
anytime you need to change it you would just change nItemNum and requery. IMHO it's much better than using filter.
Cetin