combo box to update record via form

  • Thread starter Thread starter tecas
  • Start date Start date
T

tecas

I have a combo box that displays the EmployeeID, FirstName, and
LastName from the Employee Table. The user is to pick the employee and
I want the ID stored in the DataEntry table. The combo box pulls all
of the employees from their table via the following query associated
with the combo box

SELECT tblEmployeeInformation.[Last Name], tblEmployeeInformation.
[First Name], tblEmployeeInformation.[Employee ID]
FROM tblEmployeeInformation
ORDER BY tblEmployeeInformation.[Last Name];

I have the bound column for that combo box set to 3 yet the table
always updates with the employees last name. How to i set this up so
that the table updates with the employee's id number?
 
I have a combo box that displays the EmployeeID, FirstName, and
LastName from the Employee Table. The user is to pick the employee and
I want the ID stored in the DataEntry table. The combo box pulls all
of the employees from their table via the following query associated
with the combo box

SELECT tblEmployeeInformation.[Last Name], tblEmployeeInformation.
[First Name], tblEmployeeInformation.[Employee ID]
FROM tblEmployeeInformation
ORDER BY tblEmployeeInformation.[Last Name];

I have the bound column for that combo box set to 3 yet the table
always updates with the employees last name. How to i set this up so
that the table updates with the employee's id number?
Click to expand...

What's the Control Source of the combo box? Do you perhaps have this table
defined as a <yuck!> Lookup Field? Perhaps it's *storing* the ID but the
Lookup is *displaying* the name.

John W. Vinson [MVP]
 
I have a combo box that displays the EmployeeID, FirstName, and
LastName from the Employee Table. The user is to pick the employee and
I want the ID stored in the DataEntry table. The combo box pulls all
of the employees from their table via the following query associated
with the combo box
Click to expand...
SELECT tblEmployeeInformation.[Last Name], tblEmployeeInformation.
[First Name], tblEmployeeInformation.[Employee ID]
FROM tblEmployeeInformation
ORDER BY tblEmployeeInformation.[Last Name];
Click to expand...
I have the bound column for that combo box set to 3 yet the table
always updates with the employees last name. How to i set this up so
that the table updates with the employee's id number?
Click to expand...

What's the Control Source of the combo box? Do you perhaps have this table
defined as a <yuck!> Lookup Field? Perhaps it's *storing* the ID but the
Lookup is *displaying* the name.

John W. Vinson [MVP]
Click to expand...

I just finished checking my table prior to reading your post and the
previous developer had the field in the table defined as a <yuck!>
combo box. I changed all of the afftected fields (yes, there was more
than one defined that way in the table) and my data magically
appeared.

Thanks for the response.
 
Hi Tecas,

As you have discovered, Lookups defined at the table (or query) level art
thy creation of thy evil one. See the 2nd Commandment, here:

The Ten Commandments of Access
http://www.mvps.org/access/tencommandments.htm

Access MVP Alumnus Jeff Conrad has a slick add-in tool available that you
can download and install. One of the features of this add-in includes the
ability to quickly locate all table lookups. You might want to give it a try:

CSD Tools Database Documentation
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

*Note: This tool has not been updated for Access 2007


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Back
Top