I am have a slight problem with my Select LIKE statement. I have attached a screenshot for a better understanding.
I have tried following the advice on microsft's page, however it still does not work. Hope you can advice me on what should i do. Thanks.
My button's Code below:
Private Sub btnSearchByActors_Click()
Me.listboxMovieListing.RowSource = "SELECT Movies.MovieId, Movies.Title, Movies.UnitRentalFee, Movies.Ratings, Movies.Qty FROM Movies WHERE Movies.Actors LIKE " & "*" & Forms!fmMoviesAvailableForRent!tbxMovieActors & " * "