report filter using combo (newbie help)

[podrae]

Hi Guys



I have a form with a nested report that I want to filter based on four combo box selections + a general word. I have searched this for ages and found heaps of stuff on it so its obviously something that alot of people run into when learning this stuff. I have very limited Access experience but a wee bit of C# from years ago. I am struggling to piece together code and things I have found to apply to my own situation so thought I may be able to pick up what exactly is going on if I get some help with my actual database.

This is for a car part inventory
table for year
table for make
table for type
table for general part

main table that holds actual part and all of the above


Situation is this.

I have a form with four combo boxes bound to tables, makecombo, generalcombo, yearcombo and typecombo. I also want to add a text box I can type in to narrow further (i have done this with the query builder LIKE "*" & [part] & "*")
Under this is a report that is currently showing all data in the "part" table.

I want to be able to pick a value in each combo box, type something in the text box then click a button which then adds all the values together into a select statement or something which then updates the nested report to show the filtered results.

If someone could help me with the code I need here and where to place it I would be greatly apprecitive.

Tony

[June7]

Review:

http://www.datapigtechnologies.com/f...tomfilter.html

http://www.allenbrowne.com/ser-62.html

[podrae]

Review:

http://www.datapigtechnologies.com/f...tomfilter.html

http://www.allenbrowne.com/ser-62.html

This was a bit confusing still but I managed to get my combo boxes creating a perfect SQL statement by fiddling with the code supplied here http://www.access-programmers.co.uk/...d.php?t=157601

[orange]

There are 2 combobox videos on Datapig. Well done and often referenced.
You could adapt to work with 4.
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html