Search results

thank you, take your time. Would have been really nice to get it to work.

Don't take this the wrong way, I really appreciate you're helping me, but still, you don't use check boxes, now you're using radio buttons. I want it to kind of look like the picture I posted in my first post. For example, if you check comedy, 2006 and 2007 all comedies from 2006 and 2007 will...

I see that you have made a listbox, looks great! I still want to use check boxes to select which genre and release year it should filter. Do you think you can show me how to do this too? This is where I'm stuck right now.

I don't know how to thank you, I will look at this and let you know what I think.

absolutely, I want to learn these things, but it's kind of hard...maybe I understand when I look at your db.

What is QBE Pane? It would really help if you made me a db, like the one you did earlier, but instead of combo boxes use check boxes. Because right now i can't see how to solve this :(

The listbox is doing what it should now :) I tried to remove the combo boxes for both genre and release year and replace them witch check boxes, now I don't know what the query should look like...:/ I tried to replace this... (((tbl_movies.Title) Like ("*" & [Forms]![Form1]![Title] & "*"))...

ok, the weird thing is that when i choose to get a form "view" of the subform and change the titlebox into a list, it ain't showing any titles, can you please check this? And one more question, let say that I want to add another search criteria, what should i do to get that to work in the same...

I feel kind of confused...how do i change the format of the subform so that it ain't showing me the table but a list? Then i just don't understand how the subform can update so fast without me even pressing a search button...is this because of the query in the form1? thank you for helping me :o

It works very good as it is right now. Can i make the subform a listbox? I want my titles to show up in a list... I also want to use check boxes instead of combo boxes, is this possible? how should I do? wish I was better at this...:(

If you don't have access 2007 you can download this instead, a 2003 .mdb file.

I have done a new db in english, I only made the tables and the search form, so maybe you can do the subform and query/VBA?

of course I can send you a copy, but right now everything in my DB is in swedish, should i translate it into english for you?

when I open the form it asks for Forms!frm_search!title_input when I press enter all my movies shows up. So far, so good except that when trying to transform the textbox into a listbox the results won't show in the listbox. I can see that the query finds all my movies, but they don't show up in...

Hi I have deleted my listbox. I then made a query that look like this.. SELECT Movies.Title FROM Movies WHERE Movies.Title LIKE "*" & Forms!frm_search!title_input & "*"; I then made a form (my subform) based on that query. Have I done right so far?

yeah, me too. once more, thank you!

A great example db! I understand why I need to do the combo boxes. Do I need to use VBA or a query is enough? What is the next step for me to do?

many thanks to you for your effort! I will go through your example and keep you updated.

ok, I'm starting to understand. are you saying that I should delete my checkboxes and use combo boxes instead? Maybe I understand if you make an example db :o

Thanks for replying! Maybe I should have said that I'm not that good when it comes to these things. I understand what I need to to with the list, make it a subform based on a query that uses titlebox as criteria. I don't understand the part with making comboboxes :confused: I absolutely...