Hi

I have a query that uses 2 variables from a form. All the query is doing is checking whether the 2 variables exist in a table. 99% of the time there will not be a match. Does anybody know how you supress the query from being displayed when no results are found?

Thanks

Andrew

Before you run the query, use DCount() to do the same search. If the count is 0, don't run the query.

Hi

Thanks for reply and bear with me as I haven't used access for over a year.

Tried the following code:

Dim vInvNo As Variant
Dim VPayee As Variant
Dim Count1 As Long
Dim Count2 As Long

vInvNo = [Forms]![frmInvoiceInput]![Text60].Value
VPayee = Me.[Combo52].Value

Count1 = DCount("Amount", "tblInvoices", "Payee = vPayee")
Count2 = DCount("Amount", "tblInvoices", "Invoice No(s) = vInvNo")

If Count1 > 0 And Count2 > 0 Then
DoCmd.OpenQuery "qryInvoiceCheck"
End If


Basically I'm having probs with the "Payee = vPayee" part in count1 ie how do you include variable in the function?

Cheers

Andrew