how to test wether or not a query returns a record 1

[benwah]

Hi

I want to run a query from VBA code and detect if it returns a record. So all i want to know is Yes it does return a record or No it doesnt return a record.

Is this possible?

cheers
wah

 

[Maquis]

Yep, I do it all the time.

Dim reccnt as integer
RecCnt = DCount("KeyField",Queryname)
If RecCnt > 0 then
'you got records
Else
'you don't
End If Maq B-)
<insert witty signature here>

 

[benwah]

Cheers! Worked a treat!