Recent content by mjpr54

I think I can handle the multi-select list box part, but not sure about the filter part. Any help would be appreciated.

I believe many to many relationship between tables is set up correctly. I already have a form set up so I can query title by actor. the Query criteria looks like [forms]![formname]![comboboxname] And I have a button on the form to run the query.This allows me to select an actors name and the...

I have a db for movies that I own. I would like to make a query so that I could find movie title if I can remember several of actors in the movie. for example " what is the name of the movie with Paul Newman and Robert Redford" Any suggestions ?

Thank you sir, you have accomplished in a few hours what I have been working on for months. Guess it helps if you know what you are doing. I will polish it up and put it to use. Thanks again

Thanks, I appreciate your help

Thanks again, your sample works great, but still not quite what I am looking to do. Lets say the wife and I are trying to decide what movie from our collection we want to watch. I want to find a western with clint eastwood. Or find a PG rated comedy. Or that movie with tom hanks and meg ryan in...

Ok take a look at form SearchF....that feeds Total Query. I appreciate your help

thanks will see what I can do

I dont think so.....to large to attach I believe. Other options ?

Tried that....but if you group by first and movie is western and als drama if criteria is drama it will not show this movie....am I doing something else wrong? Thanks

I have a db for movies with some many to many relationships ie movie has several actors or several genres. How can I run a query that does not return all results for the criteria field, but still searches through them. For example I would like to be able to run query for all movies from 1972...

Tank you!!! Problem solved

Trying to run query with criteria based on combo box in search form with no luck. If I use text box in search form I can make it work. About to pull out what little hair is left. Any ideas or suggestions ?

I have a multi value combo box in a form that populates another table. Is there a way to make it so when you begin to type in the box a record is suggested, ie. type the letter "c" and records beginning with the letter "c" are brought up and then and then a selection can be made. As it is now I...

Thanks, I will look at this and see if I can adapt for my use