Text Entry to Autopopulate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with the fields: Name, Email, Phone, Machine Number, and
Department. The database is set up so that when the name is chosen from a
drop down list, it autopopulates the rest of the fields.

What I am trying to do is when I type the name into the name field and hit
TAB or ENTER it will do the same thing. So far, I can't get it to work

Please Help !!!!

Karim
 
Karim:

Storing the same values for each field in multiple rows in a table
constitutes redundancy and leaves the door open to update anomalies. The
values for each person's attributes should be stored in just one row in a
separate table whose primary key is referenced by the referencing table.
Lets assume the referenced table is called Employees and has an autonumber
primary key EmployeeID. The referencing table should have a foreign key
EmployeeID of long integer number data type (not an autonumber this time).
This should be indexed non-uniquely (duplicates allowed).

To see the other attributes of the person base a form on a query which joins
the two tables on EmployeeID. Include a combo box bound to the foreign key
EmployeeID field with a RowSource property such as:

SELECT EmployeeID, EmployeeName
FROM Employees
ORDER BY EmployeeName;

Set the combo box's other relevant properties as follows:

BoundColumn 1
ColumnCount 2
ColumnWidths 0cm;8cm (or equivalent in inches)
AutoExpand Yes

With the ColumnWidths property the second dimension is not crucial so long
as its at least as wide as the control. The first must be zero, however.

The user can either select a name from the list or type one in. In the
latter case the first match from the list will be automatically completed as
the user types each character.

Ken Sheridan
Stafford, England
 
Back
Top