Solved.....Help with And in Dlookup statement (Number Value and Text Value) from form

[MightyRoo]

Hello,

I can get the following to return the results I need....

(BrandIdLink is a number)

NumberOfModels = DCount("[XModelIDLink]", "QryBrandsWithMultipleModels", "[XBrandIDLink] = " & Me.BrandIDLink)

And
(DeviceType is text)

                                        NumberOfModels = DCount("[XModelIDLink]", "QryBrandsWithMultipleModels", "[XDeviceType] = '" & [DeviceType] & "'")

However, as hard as I try I cannot get them together without errors.

Help would truly be appreciated.

Thanks,

Scott

 

[MightyRoo]

Got it.....

NumberOfModels = DCount("[XModelIDLink]", "QryBrandsWithMultipleModels", "[XBrandIDLink] = " & Me.BrandIDLink & " and [XDeviceType] = '" & [DeviceType] & "'")

And then Finally

NumberOfModels = DCount("[XModelIDLink]", "QryBrandsWithMultipleModels", "[XModelIDLink] = " & Me.ModelIDLink & " AND [XBrandIDLink] = " & Me.BrandIDLink & " and [XDeviceType] = '" & [DeviceType] & "'")

Hopefully this helps someone else!