Hi Guys, i cn see a couple of mistakes pointed out from your reply, much appreciated, will be having a play around with it this morning..
"Select * From tblEdit WHERE DelTo = '" & mDealer & "' And ShipmentDate = #" & Me.cboShipmentDateIndex1 & "# ORDER BY Product" I will close off criterias before next criteria
"Select * From tblEdit WHERE DelTo = '" & mDealer & "'
" & "
And ShipmentDate = #" & Me.cboShipmentDateIndex1 & "#
"& "
ORDER BY Product"
The annoying part is it did work and going back to your point about testing for an empty recordset, the shipmentdate is based on a combo that must have records as is mDealer from that shipment date, the records have got to be there as these are not dates and dealers are from the tblEdit ! ? please correct me if I am wrong ??
It may be wise I put a MsgBox after declaring recordset ie: MsgBox(rs.RecordCount) etc....
much appreciated guys because sometimes I can't see the woods because the trees ae in the way