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

Hi Coby

This is what I use to check. if no records, then it exits the function. Obviously if you want it to do other things, just put the else statement in there

If rstTempWIP.RecordCount <= 0 Then Exit Function


Hope this helps

Martin

Thanks, that did the trick.

Coby.