Select value in comboBoxes to filter records

[GetReel]

I not sure how to explain this but here goes.
I have created a form that 3 or more combo boxes and a subform with all the data from a tbl called tblLocationSpecies . When a selection has been made from the LookUptables, I want to click a run query button to find all the records that match the selecions from the combo boxes. The Cbo's are not cascading but are unbound.

The subfrom as a datasheet will show who conducted the survery and the species that they collected during a certainn year.

e.g
cbo1Location (eg King River etc)
cbo2Species (eg blackfish etc)
cboProtectionStatus (eg Volunerable etc)


River Species Status Officer SuveryYear Size
king blackfish Volun me 2002 330


anyone have any sample of how I would do this.

 

[bradcccs]

do a search on Dynamic Queries

I think that should keep you entertained for a while


Brad

 

[GetReel]

So thats what it is called....Cheers bud!

I hope I wont be here all day searching..hehe

 

[bradcccs]

Here's one for you:

Query by form using dynamic query:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=45163

Quite a good thread. Includes a link to an MS KB that should get you going.

Have Fun

Brad