Applying a filter to Main form and SubForm based on InputBox
Posted on 2006-06-26
I have a main form and a subform in Access. I would like to apply a filter to both based on an input box. The input box will prompt for the orderID. OrderID is a field in both the main and subform. I have the following but it keeps asking me for Temp.
Private Sub Find_Order_Number_Click()
On Error GoTo Err_Find_Order_Number_Click
Dim Temp As Long
Temp = InputBox("Enter the Order ID", "OrderID")
DoCmd.ApplyFilter , ("OrderID = Temp")
'.Filter = "strOrderID"
'.FilterOn = True