Help creating a search form.

[CarysW]

Hello

I need some advice, I have attached a sample of my database and I need to know if what I'm planning to do is too ambitious!

I want a multiple search - so a user can search for all stores in a certain county who sell a certain brand(or more than one brand).

The Search Code, Debtor Number, Business Name, Trading As, Town and Postcode fields would be a typed search.

The County, Region, Country and Rep would be given choices.

The checkboxes would be checkboxes(if you see what I mean).

The results would be shown in a datasheet view and I want to have buttons to create a report and export the resulting data.

I slightly understand what I need to do but have only seen it done with a few options - will I be able to do it?

ETA: My actual database contain over 1700 entries - I have just picked off a few here.

 

[John Big Booty]

Perhaps you could utilise the Cool Search tool discussed in this thread

 

[CarysW]

Perhaps you could utilise the Cool Search tool discussed in this thread

Thanks I'll have a look.

 

[CarysW]

Perhaps you could utilise the Cool Search tool discussed in this thread

That's not quite what I want to do as I want to have a few options to search with.

 

[TIbbs]

You might really need is to filter the records, try Allen Brown search tool:
http://allenbrowne.com/ser-62.html

 

[CarysW]

You might really need is to filter the records, try Allen Brown search tool:
http://allenbrowne.com/ser-62.html

Thanks, that looks pretty good.