use count query result in an IF statement

M

michael goodall

can anyone send me the code to use the result of a count query in an
IF statement. i basically want it to be like IF count result = 1 THEN
open form swimmers ELSE open form error. many thanks michael
 
G

Guest

Try

If Nz(DlookUp("FieldName","QueryName"),0)=1 Then
Docmd.OpenForm "swimmers"
Else
Docmd.OpenForm "ErrorForm"
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieving query result in code 2
result query on a form 1
Result in message box 3
sum a count column in query 2
Need to show result in message box 1
How to do a Max Count in a query 3
set value of txtbox in form = select query 2
Query with "In" in the WHERE clause isn't updateable 1

Top