Hello,
I am having trouble figuring out how to make a msgbox come up if my filter contains no records.
I have the following code on the afterupdate event of a combobox that searches my forms recordset by customer name:
Me.Filter = "[tblSalesOrders.Acct]=" & str(Nz(Me![LocateSalesOrderCustomer], 0))
Me.FilterOn = True
thanks for any suggestions
BJF
I am having trouble figuring out how to make a msgbox come up if my filter contains no records.
I have the following code on the afterupdate event of a combobox that searches my forms recordset by customer name:
Me.Filter = "[tblSalesOrders.Acct]=" & str(Nz(Me![LocateSalesOrderCustomer], 0))
Me.FilterOn = True
thanks for any suggestions
BJF