populate Employee info in an access from

  • Thread starter Thread starter Dale
  • Start date Start date
D

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?
 
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."
 
Back
Top