Filter Certain records Only

[Rony]

Hi
I have continous form bound to a table directly.
Table has a field [SP] and the data include
Fx
Ld
*
CD
..
While opening the form I want form to exclude * records in the form. How
can i do that.

Thanks
Ron

 

[Ofer]

Add a criteria to the record source of the form

Select * From TableName Where [SP] <> "*"

Or
Select * From TableName Where [SP] Not In ("*")