You can do what you want strictly from VBA. First, build a query template in the query designer. Let's call it "qryTemp" for good measure and assume your table is named "tblTest" with three text fields, "Field1", Field2" and "Field3". Then, build your SQL string in code and use the following to run the query.
Code:
Public Sub testIt()
Dim strSQL As String
Dim strInput As String
'All fields are text data types - modify the syntax for the query to suit your needs
strInput = InputBox("Enter your criteria", "Input")
strSQL = "SELECT tblTest.* FROM tblTest WHERE (((tblTest.Field1)='" & strCriteria & "') AND ((tblTest.Field2)='" & someFunction(strCriteria) & "') AND ((tblTest.Field3)='" & someOtherFunction(strCriteria) & "'))"
CurrentDb.QueryDefs("qryTemp").SQL = strSQL
DoCmd.OpenQuery "qryTemp"
End Sub