Result of queries

[JL]

I do not know where DoCmd keeps its return value. If it
does or not.
But I can suggest a alternative.

Using what you already have
(If the FACILITY_NUMBER is Number Type)
SQL = "FACILITY_NUMBER = " & FACILITY_COMBO.Column(0)

(If the FACILITY_NUMBER is Text Type)
SQL = "FACILITY_NUMBER = '" & FACILITY_COMBO.Column(0)
& "'"

Ctr = Dcount("FACILITY_NUMBER", "FACILITYMARKETTABLE", SQL)
It will store how many number matched FACILITY_COMBO.Column
(0) in variable Ctr.