Speeding up Zipcode lookup form

Have you ever looked up a new zipcode within axapta and it takes forever to actually take you to the one you entered? Well below is code that you can use that replaces the lookup, and only pulls in what you have typed:

// Changed added that will make the lookup faster based on what is typed in - JBG -
if(CallerAddressMap.ZipCode != "")
{

zipCode_ds.query().dataSourceTable(tableNum(ZipCode)).addRange(fieldNum(ZipCode, ZipCode)).value(CallerAddressMap.ZipCode);

}
// END

So with this you get only the addresses you are looking for to pull up, plus it happens a whole lot faster.

Well look for more code, To Increase posting, and my review of the book by Scott Hamilton "Managing your Supply Chain with Axapta"

Find a job at: www.DynamicsAXJobs.com