Populate fields in form by changing value in combobox

[Shweta]

Hi,

I have a employee_table with five fields:- Emp_code,Emp_name,Salary,DOJ,Status

I have a userform with one combobox and four textboxes. In combobox I have a list of Employee codes(taken from the above table) .

What I want is textboxes fields to be auto-populated from the given table on selection of Employee code in combobox.

I hope I am clear on my query. Please revert in case of further clarification.

Thanks!

Regards,
Shweta Jain

 

[xenou]

Hi,
You can search for this topic by googling keywords "cascading comboboxes msaccess" or "dependent comboboxes msaccess".
You will find a few different strategies, I think. The tutorial I have followed and implemented before is this one:
Access Tips: Cascading Lists for Access Forms

ξ