Hello everybody,

I've been working in my college project which is a simple movie database.

My problem is the following,

1) The user has to input a keyword in a textbox and then select a field (Title, actors, director, rating, release year and category) after that the user has to click the button which runs the macro and opens the Query.

what I have so far in the query is this:

SELECT tblMovies.Title, tblMovies.ReleaseDate, tblMovies.Director, tblMovies.Category, tblMovies.Rating, tblActors.LeadingActorOne, tblActors.LeadingActorTwo, tblActors.LeadingActorThree

FROM tblMovies INNER JOIN tblActors ON tblMovies.MovieID=tblActors.MovieID

WHERE tblMovies.Title Like "*" & (forms!frmSearchMenu!txtKeyword) & "*";

As you can see I'm only searching in the Title part but I have to choose where I want to look with the combo box! :S please help me with this problem :(

Any suggestion will do. Thanks in advance.

9 Years
Discussion Span
Last Post by Rashakil Fol
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.