K
Kutty
How to do the Combo Box?
Please inform me. I will do this for my Employees
database.
[email protected]
Please inform me. I will do this for my Employees
database.
[email protected]
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Ofer
You can use google searching for "create combo box" microsoft access, you'll
get alot of addresses, there one for example
http://msdn.microsoft.com/archive/d...ngComboBoxesandListBoxesinMicrosoftAccess.asp
get alot of addresses, there one for example
http://msdn.microsoft.com/archive/d...ngComboBoxesandListBoxesinMicrosoftAccess.asp
J
John Vinson
How to do the Combo Box?
Please inform me. I will do this for my Employees
database.
[email protected]
You will have to explain what you want to "do" with a combo box!
A Combo Box is used on a Form to update the Form's recordsource table.
It "pulls" data from one table, displays one field, and stores a value
(which might be the same or a different value than the one displayed)
into the table.
For instance, if you have a table of Departments, you could have a
Combo Box on the employee form. It would be based on a Query selecting
the DepartmentID and DepartmentName; the DepartmentID would be the
"control source" to store the departmentID in your employee table, but
display the department name. The Combo Box wizard on the form design
toolbar will walk you through creating one.
John W. Vinson[MVP]
K
Kutty
I have inserted a field "department" in employee form as Combo Box. But once
I enter the department name from Combo Box and go to next record the entered
department in previous record not saving. Once I enter a department name in
any record the remaining all records shows the same name in the department
field. why? Please reply to me
I enter the department name from Combo Box and go to next record the entered
department in previous record not saving. Once I enter a department name in
any record the remaining all records shows the same name in the department
field. why? Please reply to me
J
John Vinson
I have inserted a field "department" in employee form as Combo Box. But once
I enter the department name from Combo Box and go to next record the entered
department in previous record not saving. Once I enter a department name in
any record the remaining all records shows the same name in the department
field. why? Please reply to me.
It would seem that you have put a combo box on the Form, but you have
not put a field in the form's Table.
A form DOES NOT STORE ANY DATA. It's a tool, a window. Putting a combo
box on a form will NOT store any data anyplace.
John W. Vinson[MVP]
K
Kutty
John,
I told you I have inserted a field namely "department". I can see all the
department I stored in this field. As I told you the only problem is once I
go to any record and input any department the department name is coming from
Combo Box. Then I can see any record the same. For example in case I input
department name "sales" all other records shows sales itself. I hope you
got my point now
I told you I have inserted a field namely "department". I can see all the
department I stored in this field. As I told you the only problem is once I
go to any record and input any department the department name is coming from
Combo Box. Then I can see any record the same. For example in case I input
department name "sales" all other records shows sales itself. I hope you
got my point now