I have an Access form that runs a search on a query and returns the results to a listbox on the same form. I have two question regarding the search functionality.

1. Is it possible to search for the exact value for instance I have a Movie rating column and if I put in G and search I get the results for G, PG and PG-13 when all I wanted were G movies..

2. Is it also possible to search starting with the first letter. For example if I put an S in the Movie title line it will only return Movies starting with the letter S and not every single Movie with an S in it.

Thanks in advance for any help it is greatly appriciated.

1.
Create a text box and command button, Command button on-click event should be set to save the value in the text box to a variable, say srchstr, and then generate a query with the following syntax:

"SELECT * " & _
"FROM Movies " & _
"WHERE Rating = '" & srchstr & "';"

2. Same thing but with the query as
"SELECT * " & _
"FROM Movies " & _
"WHERE Title LIKE '" & srchstr & "*';"

Your a Hero thanks a million! This is exactly what I was looking for. Sorry for the noob questions but I am learning :)