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.

Ask in the Databases forum??

This isn't really a databases question; this is a "I can't do even the simplest of programming" problem.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.