Data retrival

[joevb84]

Hi everyone


I have 2 tables staff details and staff deductions in access.
Now i have a form which is connected to staff deduction ( i have coded the connection). I have various fields like empno, emp name, doj etc. Some of the fields are similar with fields in tbl staff details.

Moment i type in the empno in the form connected to staff deduction i want the rest of the fields which are common in tbl staff details to be retrived and filled into the form.

Is this possible? Similar to a "dlookup" in access...

Please help..

Thanks in advance

[VBFnewcomer]

download the attachment in the in this link at post #2.
Hope its helpful