Test Query Results

[funderburgh]

Can someone tell me how to test a Requery to see if it returned any records to the recordset? I want to add a user message explaining the the parameters choosen found no records. Thanks for any help

 

[RuralGuy]

If the RecordSet has any records then the RecordSet.RecordCount will not be 0.

 

[funderburgh]

Thank you very much. Please go back to puttering (I guess that is not "putting").

John

 

[RuralGuy]

You are correct. It is not putting.
http://dictionary.reference.com/browse/puttering

 

[funderburgh]

Actually if you saw my golf, the distinction might blur a bit.