To do what you want, you'll have to learn some VB programming. You can write code behind the Change event of the text box on a form that contains the 9-digit number. When the length is 3 or greater, open a recordset or use DLookup to find the related city name to put in another text box on the form.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Derhuse > Sent: Sunday, July 24, 2005 12:32 PM > To: [email protected] > Subject: [ms_access] automate lookup > > > hello all i am new to access and not a programmer > i have a access database with several feilds one field has a 9 digit > number the other has city names is there a way to type in the number > and have the city name populated as soon as the first three digits of > the nine digit number are entered > > > > > > > Yahoo! Groups Links > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
