Help needed with query!

[club monkey]

Hi, For my final year project at UNI, I have created a database in Access for a video store. The database has forms which allows users to search records. The problem is that I want users to be able to search records which match the criteria they require e.g. Certificate (18, PG etc), Category (Comedy etc) etc. For this the users must select 1 item from each combo box on the form. Then the user needs to click a command button for what type they want e.g Video, DVD or both. I then want ONLY the data that matches the combo boxes and command button (type) displayed on a new form.
So if that makes sense and you know how to do it, please reply. Thanx

 

[Birdy]

Try creating a seperate search screen and then using the search criteria in a Query.

 

[Rich]

Search here for cascading combo boxes you'll find many answers.

 

[Hayley Baxter]

I have a few working samples of cascading combos that I can send onto you. Post back if you want them.

Hayley

 

[club monkey]

If u can post me the examples, please send them to wm279073@stmail.staffs.ac.uk. Thanx for ur help. Rob

 

[ColinEssex]

I would use an Option Group to select the video or DvD or both - instead of a command button.

Col

 

[Hayley Baxter]

I have sent the samples onto you, let me know if you have any probs receiving them. These examples only show you how to work with cascading combos but if you do want the results to appear on another form, use a cmdbutton to open form then choose display specific record then choose the two matching fields by clicking <> in the wizard.

 

[club monkey]

Thanx Hayley, That is exactly what I am after. All I need to do now is implement it into my program. Once again, Thanx.