Is there any way to modify code in the form: line
stLinkCriteria = "[ACCTNO] = [Enter Loan Number]" so user can use wild cads to input.
Purpose of the question: Loan Number being inputted in the format
I would like to modify code so if user by typing in the box "*123456*" should be able to retrieve loan information instead of typing full loan number.
See attached screen shots for your reference
Private Sub cmdIndLoan_Click()
On Error GoTo Err_cmdIndLoan_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Financial-Table form"
stLinkCriteria = "[ACCTNO] = [Enter Loan Number]"
Caption = "INDIVIDUAL LOAN MODE"
DoCmd.OpenForm stDocName, , , stLinkCriteria