If SQL returns no results..dataset becomes invalid...then error

[DizzyMonster]

Hi,<br>&nbsp;&nbsp;&nbsp;Hope someone can help me. I have a find button that returns the results from a user entered box. Everything is fine if the SQL statement retrieves something and sets the Dataset to something....When it doesn't it crashes as 'no Record Selected' how can I trap it and stop it doing this???<br><br>Thanks.

 

[DizzyMonster]

Error No Current Record is what I get..

 

[Honda]

The answer to your problem is:<br><br>Put in a test for both BOF and EOF for the recordset, if both are true then no records have been found, and you can exit the the sub or do whatever..<br><br>Something like this<br><br>If RS.EOF And RS.BOF Then...<br><br>This traps the no record selected,just as you wanted too !!<br>