Please tell me How to do

[Kutty]

How to do the Combo Box?
Please inform me. I will do this for my Employees
database.

(e-mail address removed)

 

[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

 

[John Vinson]

How to do the Combo Box?
Please inform me. I will do this for my Employees
database.

(e-mail address removed)

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]

 

[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

 

[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]

 

[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