How to Populate data from table to form

[doubt]

Hi,

I am sure this sounds simple to most of you. I am working on access2002. I
have a form which has employee details. This form is bound to a table. All
the navigation buttons work fine including the addnew button. My question is
,
1. I would like to enter the employee ID at the employee ID text box in the
form (btw the employee ID is the primary key) which should inturn populate
all the other textboxes with the data related to the employee ID I entered,
if found in the table.
2. If the employee ID was a listbox instead of just a text box which listed
all the employees from the table, I should be able to populate the other text
fields with data related to the employee ID I choose from the list

Thankyou.

 

[fredg]

Hi,

I am sure this sounds simple to most of you. I am working on access2002. I
have a form which has employee details. This form is bound to a table. All
the navigation buttons work fine including the addnew button. My question is
,
1. I would like to enter the employee ID at the employee ID text box in the
form (btw the employee ID is the primary key) which should inturn populate
all the other textboxes with the data related to the employee ID I entered,
if found in the table.
2. If the employee ID was a listbox instead of just a text box which listed
all the employees from the table, I should be able to populate the other text
fields with data related to the employee ID I choose from the list

Thankyou.

Add a new Combo box to the form header.
Use the Combo Wizard. Choose the 3rd option on the first page or
questions, something like "Find the record ... etc."
Include the EmployeeID, EmployeeName and Department in the Combo box
Row source.

When done, find the EmoloyeeID in the combo and that employee's
records will be displayed.