Hi Sunil,

You can set RowSourceType to 3 and set RowSource to "SELECT ... FROM ... WHERE ..."

MartinJ

>I am having using list box to select a value on form. I am using the RecordSourceType = 2 and Rowsource = author.authcode,auth_sname,auth_fname,auth_mname
>
>I want to put a filter condition on this. Can I do that ?
>
>Pl. Help.
>
>Thanks in Advance.
>
>Regards