find an order

Topic

New Reply

I have a list box called OrderID.It contains different orderID clasified per
orderdate.I want to create a control on the form, and a code to find a given order.
I have put the folowing code in the ONClick event of the control:
Dim strOrderID As String
Dim strBookmark As String
strOrderID = InputBox(“Enter order number “)
Forms!FOrderinformation.RecordsetClone.FindFirst “orderid = ” & strOrderID
If Forms!FOrderinformation.RecordsetClone.NoMatch Then
MsgBox “

Reply | Quote