Two things:

1) Is NoDataOnLoad set to True for the view?
2) Are you setting the value of the property at design time with the same data type as ab_id? For example, if ab_id is numeric, make curid = 0 in the Form Designer.


>Sorry about the confusion. Yes the " were in there (the view designer kept putting them in, that thing is a little funny).
>
>Here is the select now:
>
>SELECT *;
> FROM workman!addressbook;
> WHERE Addressbook.ab_id = ?thisform.curid
>
>Now I get a operator/operand mismatch when the form runs.
>
>
>
>>Hi Roi ----
>>
>>Change the word "filter" to "parameter"...it's confusing. Anyway, are the double-quotes in the parameter of the view. If so, that would be the cause. It should be
>>
>>SELECT * FROM table WHERE curid = ?THISFORM.curid
>>
>>>I have a prop on the form - CurId.
>>>
>>>I changed the filter to "thisform.curid" and ?"thisform.id" but the view doesn't contain any data. If I change it back to a var - lcCurId - it works.
>>>
>>>Should the filter be something else?