A while back I wanted to create an address field where the end user only inputs the first few numbers of the address and the choices show up underneath in a drop down box, and the user chooses the appropriate address versus typing it in completely. So, for example, if a user types in '123', the drop down box would reveal their options 123 Cedar Rd, 123 Main St, 123 Norfolk Ave, etc. This would hone in on the address they were looking for and the user would select from the narrowed list. The project I was working on got corrupted some how and can;t figure out how I did it. Not sure if I used the pull data function... Can someone help me out here and point me in the right direction, perhaps with a sample sheet? Thanks very much!
