Run time error'13' Type mismatch

[lawdy]

On my form, I have a field cboSelectWhat with a row source of SELECT DISTINCT [fTxtPropertyName] & " -" & CStr([fLngPropertyNumber]) AS fBoth, tblProperties.fTxtPropertyAddress, tblProperties.fTxtPropertyCityFROM tblProperties; and the (short version) table contains:




fLngPropertyNumber fTxtPropertyName fTxtPropertyAddress fTxtPropertyCity
1141 Meadowcreek Village Apartments 933 Bruton Road Mesquite
1142 Kmart 3601 W. Northgate Irving
1143 Kmart 151 Meadowview Court Terrell
1144 Kmart Northwest And Abrams Dallas
1145 Medical Arts Building Garage 1307 8th Avenue Fort Worth



The problem is; I want to be able to type in the property name to select the property. Then I need the property number to filter it because there are properties with the same name but different address. I can separate the number. The code above works as a query, but does NOT work when used as row source. I hope this is clear to you. Any help is appreaceted.

[lawdy]

I failed to mention that I get the 'Type mismatch' when I run it as row source.

[orange]

What exactly is the fTxtPropertyName for properties with numbers 1142, 1143,1144?
Show us the design of tblProperties.

[Welshgasman]

Why isn't the autonumber the first field, and the fboth the displayed field?

[Micron]

I don't see the need for the type conversion function, but you get this error when? Upon form opening? When you try to enter data? Is anything highlighted or mentioned in a way that tells you which field raises the error?

I want to be able to type in the property name

Where? In the combo I presume.