making an advaced search form

[Pooya.Alipour]

I want to make a form that contains three fields and in front each field there's a check box. I want to search by those fields ( Code , Name , Family ) and I want to make those fields related to check boxes So the user can search by differrent parameters. Finally the information will be shown in a seperate form. Please help me to do this.

 

[John Big Booty]

Perhaps the sample posted here will give you some pointers.

 

[Pooya.Alipour]

I've done something like that in the past but now my problem is different

 

[John Big Booty]

So if the check box is checked you want the data in the text box to be part of the search criteria, and if the check box is blank the field forms no part of the search criteria?

 

[Pooya.Alipour]

yes exactly

 

[John Big Booty]

In the criteria of your query try the following for each field;

Like Iif([Forms]![YourFormName]![CheckName]=0, "*", [Forms]![YourFormName]![RelatedFieldName]

Before your query is fired, you will need some code to ensure that fields related to checked check boxes contain appropriate data.

 

[Pooya.Alipour]

then you say that I should use a query?

 

[John Big Booty]

That's the way I might do want your looking for. I'd then use the query as the Record Source for your form.

 

[Pooya.Alipour]

then I will do it and then I will return to report. thank you

 

[Pooya.Alipour]

"*" means what?