The DCOUNT Function

[atrium]

I tried this and I just keep getting problems with it Error message attached

Me.TotNoForSaleFld = DCount("VehicleId", "Vehicles", "[BuyerId] = 0 And [ClientId] = " & Me.ClientsIdFld)



Any Help wou;r be appreciated

 

[bob fitz]

Try:
Me.TotNoForSaleFld = DCount("VehicleId", "Vehicles", "[BuyerId] = 0 And [ClientId] = " & Me.ClientsIdFld & ")

 

[The_Doc_Man]

Me.TotNoForSaleFld = DCount("VehicleId", "Vehicles", "[BuyerId] = 0 And [ClientId] = " & Me.ClientsIdFld)

If Me.ClientsldFld is text then your quoting is what is whacking you.

Me.TotNoForSaleFld = DCount("VehicleId", "Vehicles", "[BuyerId] = 0 And [ClientId] = '" & Me.ClientsIdFld & "'")

Take a careful look at the quoting, recognizing a mix of double-quotes and single-quote/apostrophe.

 

[Pat Hartman]

Are you sure that BuyerID is spelled correctly? Also, the DLookup() as it is coded will count only non-null vehicleID's. This may or may not be what you want. The following version will count all the rows returned by the criteria.

Me.TotNoForSaleFld = DCount("*", "Vehicles", "[BuyerId] = 0 And [ClientId] = " & Me.ClientsIdFld)