dlookup instead of sql 1

[kennetha]

Hi all,

I have created the below on a form basically to open it hidden, check if there is any data (like if dcount()>0 and then continue or stop the code when necessary. My question. Is there any other way to accoplish the task with a simple Dlookup or an Sql code?

Here's the sql;

SELECT t.idcode, t.dfrom, t.dto FROM t WHERE (((Forms!vv!txty) Between [dfrom] And [dto])) GROUP BY t.idcode, t.dfrom, t.dto HAVING (((t.idcode)="101z"));

Thanks in advance
Kenneth

 

[PHV]

You may try something like this:

If IsNull(DLookUp("idcode", "t", "idcode='101z' AND Forms!vv!txty Between dfrom And dto")) Then
  'no data
Else
  'process data
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kennetha]

Thanks PHV,

It worked fine and defitely better than opening and closing forms.

How can i change "idcode='101z'..." if it is to come from an edit box (txtidcode) in Forms!vv!?

If IsNull(DLookUp("idcode", "t", "idcode='" & Forms!vv!txtidcode AND Forms!vv!txty Between dfrom And dto")) then
...

Is it correct

Regards
Kenenth

 

[PHV]

If IsNull(DLookUp("idcode", "t", "idcode=Forms!vv!txtidcode AND Forms!vv!txty Between dfrom And dto")) Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kennetha]

Thanks you saved my day