Check box in Form

[sougata]

I have a table -'client' with 5 fields,
id
name
address
email
mobile no

Through a form,I want to list only those clients who has email id - by using check box

I know its simple but not so simple to a layman like me

Please help

 

[Moniker]

SELECT * FROM Client WHERE id IS NOT NULL;

~Moniker

 

[sougata]

Thanks

Many many thanks for reply, But please tell me where to write this command?

 

[Moniker]

That's a query. Write it in SQL. You can copy/paste what I did, or make it yourself (to match table names and such). In a pinch, just use it as the Record Source on your combo box (or form or wherever you're using it).

~Moniker