How do I know if a recordset has been filled?

[damezumari]

I use Access 2003 and WinXP.

I have a recordset declared:

Dim regValuation As Recordset

Later, I may, or may not, fill it (for a certain csql string) like
this:

Set regValuation = CurrentDb.OpenRecordset(csql)

How can I test if the recordset has been filled or not?

I have tried, unsuccessfully:

vartype()
regValuation.EOF and .BOF.

Regards,

Jan Nordgreen

[Wayne Phillips]

"damezumari" <ja**********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

I use Access 2003 and WinXP.

I have a recordset declared:

Dim regValuation As Recordset

Later, I may, or may not, fill it (for a certain csql string) like
this:

Set regValuation = CurrentDb.OpenRecordset(csql)

How can I test if the recordset has been filled or not?

I have tried, unsuccessfully:

vartype()
regValuation.EOF and .BOF.

Regards,

Jan Nordgreen

Something like this:

If regValuation Is Nothing Then

'Code if not yet assigned

End If

Regards,

Wayne Phillips
http://www.everythingaccess.com/forums

[damezumari]

Thanks!

It worked like a dream!

Regards,

Jan Nordgreen
http://simpler-solutions.net/pmachin...thinkagain.php