View Single Post
  #1 (permalink)  
Old April 27th, 2007, 10:18 AM
Coby Coby is offline
Authorized User
 
Join Date: Apr 2007
Location: , , .
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default Recordset Empty Check

Is there a way to check if a recordset has no data?
I get a "no current record" error because ther is none.
I simply want to use an if statement to check for data first.
Any Ideas would be appreciated?

EXAMPLE:
'Empty the TempTable of all Old Work
    Set rstTempWip = dbs.OpenRecordset("TempWipBatch", dbOpenTable)
    If rstTempWip. 'I am trying to check if the recordset is empty here "" Then
    rstTempWip.MoveLast
    End If

Reply With Quote