Populating demographic information

[Guest]

Hi,

I'm creating a databse to track our salary overpayments. Our HRIS is Lawson
and what I would like to do is have the employee's last name field
automatically populate with the employee's name when I enter their employee
number on the input screen or directly into the table. This information
would be pulled from the main employee table.

Any guidance would be appreciated.

thanks, Tracy

 

[strive4peace]

Hi Tracey,

rather than storing lastname in 2 different places
(especially since you are storing the employee number, which
I will call EmpNum), simply echo the Lastname value

1. make your combobox for EmpNum also show lastname (I will
assume this is the second column)

2. make a textbox control

3. set
controlSource --> EmpNum_controlname.column(1)

WHERE
EmpNum_controlname is the NAME property of the combobox for
EmpNum

column indexing starts with 0, so column 1 is actually the
second column

Is EmpNum the Autonumber field for Emplyees? By convention,
this is called SomethingID, like empID or EmplyeeID as it
what is used to link related tables. It is best for links
to be autonumbers as opposed to user-data.


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com