auto-populate field based on info entered into other field

reesa

New Member

Join Date: Feb 2011

Posts: 1

22nd Feb 2011

Hi there,

I'm new to this site and quite new to Access (using 2003) but am a quick learner. I'm currently teaching myself how to create an Access data base for client information at work.

In the database I have a field for FIRST NAME and a field for PREFERRED NAME. In cases where a client goes by a name other than the one on his/her ID we'd like to have record of it. I would like the PREFERRED NAME field to auto-populate with the info entered into the FIRST NAME field... this way I can manually change it only if necessary.

I would appreciate any tips!

Thanks, Reesa

« Re: Form - Conditional Formatting | Spinning progress indicator »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto Populate Field 2 Based on Field 1	=?Utf-8?B?U2NvdHQ=?=	Microsoft Access	3	12th Mar 2006 03:29 AM
Fill in table info based on # entered into specific field	=?Utf-8?B?ZXF1dXNjeWNsZQ==?=	Microsoft Access	4	19th Nov 2005 03:07 PM
Populate one field in a form based on value entered in other field	Tracey	Microsoft Access Forms	2	26th May 2005 01:18 PM
How do I auto fill a field based on info input into another field.	=?Utf-8?B?QnJlbmRhIEY=?=	Microsoft Access Forms	1	20th Apr 2005 03:29 AM
Required fields based on info entered in another field	Lori Mihalko	Microsoft Access Forms	7	23rd Dec 2003 02:14 AM