Set parameter in query

Hello,

I'm working with a simple CRUD application which is EXCEL (front-end) and ACCESS (back-end).

I would like to ask how can i parameterize in a query?

I have the below code for retrieving a data

Please Login or Register  to view this content.

I would like to parametize the

Please Login or Register  to view this content.

Originally Posted by xlbiznes

What is wrong with your current approach ?

The problem in my current approach is, when the user input

Please Login or Register  to view this content.

in Me.txt_Search, it will debug (Sql injection). I want to prevent it from sql injection.
Please help.

Any one can help me on this please?