This is the select command text
Me.OleDbSelectCommand1.CommandText = "SELECT Auto_ID, Last_Name, First_Name, Date_Created, Transaction_Type, Service_Type, Notes, Due_Date, SSN, Phone_Number, Address, City, State, Zip, Total_Charges, Total_Payment, Total_Balance, Created_By, Status, IsVoid FROM Transaction_Information WHERE (IsVoid = 0) AND (Auto_ID = ?)"
If i want to use a variable to populate the Parameter '?'
how would I use the Me.OleDbSelectCommand1.Parameters.Add command
and how would I go about changing the value and updating the parameters value?