Code
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.