I searched all the postings and didn't see anything that addressed this specific modification I need to make.
I have a table with streets that have a starting number and an ending number--something real common with GIS data. I want to build a standing search page so that users can (1) enter a street number and (2) use a pull-down for a street and retrieve a record that fits between the starting and ending number for the street segment.
In Access, I can enter something like 100 Main Street and it pulls back a record that shows the starting address is 1 and the ending address is 150 for Main Street.
In Access SQL, the code looked something like this:
WHERE (((All_Roads_All_Schools.NAME)=([forms]![frmLookup]![STREET_NAME])) AND (([forms]![frmLookup]![STREET_NO]) Between [START_ADD] And [END_ADD]));
I know how to do the street name pulldown--but how could a user enter a number that would search both the Starting and Ending Address number field?
I'd like for this to be something like a standing search page (use the 'No records on the first page' option in ASPRunner?) to pull back this data. Will I have to use a number pulldown? How to search both fields at once with a single number???
So I would really appreciate anybody smart out there who could help me modify this in this outstanding application.
Preston
