myaccess2000
Technical User
Hi,
I would like to show the default value on the combobox that is in the table. And there are a choice from the list that i can change the value to.
e.g In the table
Name Department
Albert Account
Jane Material
So when i open the form, it will show name "albert" on the textbox and show "account" on the combobox and inside the combox list, it should contain account, material, admin, payroll...etc....
The list that suppose to show on the combo box list, i have a table to store all the department. So i set the rowsource to department.
So how to show the "account" on the combobox when the form is open. When scrolling through, the value changes depend on the name of the person.
Please help!!!...Pardon for my little knowledge in Access
Regards
I would like to show the default value on the combobox that is in the table. And there are a choice from the list that i can change the value to.
e.g In the table
Name Department
Albert Account
Jane Material
So when i open the form, it will show name "albert" on the textbox and show "account" on the combobox and inside the combox list, it should contain account, material, admin, payroll...etc....
The list that suppose to show on the combo box list, i have a table to store all the department. So i set the rowsource to department.
So how to show the "account" on the combobox when the form is open. When scrolling through, the value changes depend on the name of the person.
Please help!!!...Pardon for my little knowledge in Access
Regards