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.