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
Set rs = New ADODB.Recordset
Set conn = New ADODB.Connection


connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\corpusfs12\GRO\RA_BACKEND\RA.accdb;Persist Security Info=false;"

SqlQuery = "SELECT ID_GRO,GEO,CUST,SOLD,EMAIL,SCONTACT FROM tbl_INFO WHERE CUST LIKE  '" & Me.txt_Search.Value & "' "


conn.Open connstring


With rs
   .Open SqlQuery, conn


End With


Do Until rs.EOF = True

    
    gid = rs.Fields!ID_GRO
    Me.txt_GEO.Value = rs.Fields!GEO
    Me.txt_CUST.Value = rs.Fields!CUST
    Me.txt_SOLD.Value = rs.Fields!SOLD
    Me.txt_EMAIL.Value = rs.Fields!Email
    Me.txt_SALES.Value = rs.Fields!SCONTACT

rs.MoveNext

Loop

conn.Close
I would like to parametize the 
Me.txt_Search.Value