Auto Populate TextBox

[Shido151]

I'm using a Web Database in Access 2010 (32bit)



I have simple software form that writes to a table where basically I enter in the employee's, ID, user name, Address, Phone Number ect ect, along with the new software they purchased.

But there is already a list (table) with this basic information (phone, address, Name) on it.

Is there an easy way set it up, so when I entered the person's employee ID number, all the other basic fields will self populate with that user's information.


I've scoured the internet for this answer but everyone talks about it reffers to 2003/2007 or they go into these long scripts that are greek to me I'll learn anything you have to offer but please keep in mind if you offer a script please tell me what steps I need to do in order to enter the script into access. (I don't even know where to write the scripts to, I literally do not know what screen I pull up to enter in the characters)

[pbaldy]

How about

http://www.baldyweb.com/Autofill.htm

[Shido151]

Well that works. Thanks a lot. However I do have one more question that a collegue brought up. Is there a way to have these text/Combo Boxes populated by Active Directory? That way we'd be pulling for a database in real time.

[pbaldy]

A quick Google turned up this among others:

http://www.dbforums.com/6296643-post48.html