populate Employee info in an access from

[Dale]

I would like my form to populate some text or combo boxes that describe
employee
Info. My Form has Employee ID, Employee Name, Anniversary Date, Gender. I
would like the name, anniversary, and gender to populate after I enter the
Employee
ID. Is this possible?

 

[Al Campagna]

Dale,
The only field you have to really capture, is the EmpID. All the other
values can, and should be, displayed using calculated fields.
A good method is to use a combo box to allow the user to select an
employee by name, but... really capture the EmpID.
The combo columns would be...
EmpID EmpName AnnDate Gender
On my website (below), I have a sample 97 and 2003 sample file called
Combo Populates Multiple Fields, that demonstrates how to setup the combo,
and get the ancillary data to display in the calculated form fields.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."