return value

[sharonir22]

hi,
I'm trying to set something based on the result of a query, meaning that if there are no results one form open, and if there is a result a different form opens.

how can I reffer to a result of a query in a form?
*just to clarify- my query always returns 1 or 0 results.
thnx

[amrut]

One way is to count the records returned by query before proceeding to open the form -
If DCount("*","YourQueryName")=0 Then
'Do this
Else
'Do something different
EndIf