Here goes the explanation, When the VendorNumber is populated and the statement [preconversion] and [letter] and [vatcompliant] = False I would like the subform to populate with only the information that is in my query VATOutstanding. For that to happen I would need the to use INVID to link the tables / querys VATOutstanding_ qry, InvoiceTracking W/Sum_qry. The problem is right now I do not have the VATOutstanding_ qry working right now as the final...

I have had this going around in my head for days now. Trying to get the correct way to do this. I tried to cut and paste my DB in here but it would not. Not sure how to show you guys everything.
This is all new to me.

OK So far I have done the following:

IIf([VATCompliance_t bl]![PreConversion] Or [VATCompliance_t bl]![Letter] Or [VATCompliance_t bl]![VATCompliant] = YES), “”, check INVID and 1st letter sent.

Iif ( [VATCompliance_t bl]![PreConversion] and [VATCompliance_t bl]![Letter] and [VATCompliance_t bl]![VATCompliant] = False ),


Expr1: IIf(([VATCompliance_t bl]![PreConversion] And [VATCompliance_t bl]![Letter]...

Ok, I am working on an Access DB (2002) that needs to show a Subform when a field is populated with a number. In this case when VendorNumber is populated and it does not match the criteria of [Preconversion] and [Letter] and [VatCompliant] =true, then I want the subform to open up with the information. The link between the form and the VendorNumber is VENID.

I have tried to use a bunch of queries but it has not given me any joy....