Multi Field Combo search Form

**Andyjones** · 03-12-2012, 01:32 PM

Hi Within the database below I have tried to create a multifield search form, however it only works when you use one of the drop down fields only,

For example If i select home in match type it show all the home results, However what i would like it to do is the following

As well as working by themselves to find the data, I need the combo boxes to worktogether when you press the run query/search button. This will then either run the query and produce report or run just a query. maybe an and parameter would be better suited for this, but if someone could be kind enough to take a look I would be most
grateful

When I select div 1 then smethick then home games it suppose to show all div 1 home games in the smetwick league

Thanks
Attached Files

Test (2).zip (387.5 KB, 2 views)

**Bob Fitz** · 03-12-2012, 02:00 PM

You may get more help if the db attached was in the mdb format

**Andyjones** · 03-12-2012, 02:07 PM

The file is to large to upload in a mdb format im using office 2010

**Bob Fitz** · 03-12-2012, 02:13 PM

Perhaps you could remove some data, compact and repair, then zip it ?

Multi Field Combo search Form

Thread Tools

Multi Field Combo search Form

Similar Threads

Not in list event and multi search form with drop down fields.

Combo Search Form

2 multi select list boxes on one search form

Form to add/edit rows in a table with a multi-field primary key

Search form multiple multi select list box's Error

Posting Permissions