Private Sub Button_Run_Click() Dim Passcode As String Passcode = TextBox.Input_Passcode.Value Me.Filter = Passcode Me.FilterOn = True End Sub
I have a MS Access Form object named Input_Passcode. This is a TextBox where a user may input their passcode and retrieve filtered content in their form.
On the same form is a Run button. When the user clicks the Run button, I want the button to take the value in Input_Passcode, and filter the form.
I don't know if TextBox.Value is the correct property to accomplish this but I'm not finding any real examples of the correct syntax.
Please help. Thanks.