How to auto populate criteria in Microsoft Access 2000?

Basically I have a table of new and old job codes "Ex. new: SACT10-Associate Accountant and old: A013-Associate Accountant". I need old job code to be auto populated in the field below when I enter new job code in access. Please share if you know how!

Asked By: - 11/10/2009
Best Answer - Chosen by Asker
As far as I can understand, you need a query that, whenever you type the new code it will show the old code of that new code... More
Answered By: Makiavel - 11/12/2009
Additional Answers (1)
Not sure if this is what you need but in the table design, click on the job code field and click in the field properties section. For Default Value, enter the code you want displayed. Save the table and go back to datasheet. When you input a new record, you'll see the job code you entered for the default value.
Answered By: Melissa - 11/11/2009
Sponsored results
Local Candidates Across DC/VA/MD. Get It Together. Post a Job Today!
Over 483 Local Jobs Now Hiring In Your Area. $18-$87/Hr - Apply Today!
Click. Search. Apply. Free!
Jobs hiring near your local area. Part-time, Full-time, Work at home.

Other Career Questions

1 answers - Asked By: - 4/5/2013
6 answers - Asked By: - 3/7/2012
What jobs are there in the business field that are night jobs? Places and job titles please. Im have a BA in Business Admin and looking for a night job, already have a morning/day job.
4 answers - Asked By: Mark L - 7/26/2008

Content is not owned or controlled by Monster. Any content concerns should be addressed with Yahoo!
Yahoo! Does not evaluate or guarantee the accuracy of any Yahoo! Answers content. Yahoo! Disclaimer.

Popular Articles

Best-Paying Work-from-Home Jobs Article Rating
It’s easier than ever to work from home. Of course, not every job is a mobile job, and some companies aren’t interested in having their employees work from home.
2013 Marketing Jobs Outlook Article Rating
The US may be facing another year of anemic hiring overall, but that won't be the case in the high-orbit world of multichannel, digital media marketing.
For Employers: Post Jobs | Search Resumes | Advertise
About Monster | Work for Monster | Advertise with Us | AdChoices | Partner with Us | Investor Relations | Social Media
Terms of Use | Privacy Center | Accessibility Center | Help | Security | Contact Us | Sitemap | Mobile
©2014 Monster - All Rights Reserved U.S. Patents No. 5,832,497; 7,599,930 B1; 7,827,125 and 7,836,060 MWW - Looking for Monster Cable? - V: 2014.1.40.24-208