Drunkenneo
Registered User.
- Local time
- Today, 14:52
- Joined
- Jun 4, 2013
- Messages
- 192
Private Sub Find_Click()
'DISPLAYING RECORDS FROM MASTER DATEWISE
Dim Order_combo47 As Integer
Dim rs As dao.Recordset
Order_combo47 = Combo47.Value
'On Error GoTo Err_find_Click
Combo47.SetFocus
MsgBox Order_combo47
Me.Report.RecordSource = "select * from Orders_Processed where order_number =" & Order_combo47 & ""
End Sub
Not working and getting highlight on "Order_combo47 = Combo47.Value" why?
'DISPLAYING RECORDS FROM MASTER DATEWISE
Dim Order_combo47 As Integer
Dim rs As dao.Recordset
Order_combo47 = Combo47.Value
'On Error GoTo Err_find_Click
Combo47.SetFocus
MsgBox Order_combo47
Me.Report.RecordSource = "select * from Orders_Processed where order_number =" & Order_combo47 & ""
End Sub
Not working and getting highlight on "Order_combo47 = Combo47.Value" why?