Hmm?
Using this Query1 SQL
Code:
SELECT tblEmployees.FirstName
, tblEmployees.LastName
, tblEmployees.EmpID
FROM tblEmployees;
I get these values in a portion of the result set???
FirstName |
LastName |
EmpID |
Tony |
Walker |
139 |
Terry |
Williams |
140 |
Victor |
Herrera |
141 |
Victor |
Villanneva |
142 |
Willie |
Bills |
143 |
Wilbert |
York |
144 |
Team
|
Alpha Bulldogs |
147 |
Team |
BAH |
148 |
Team |
Manor Regulators |
149 |
Team |
Dirty Dozen |
150 |
Team |
Heavy Hitters |
151 |
Team |
Roll as One |
152 |
Team |
Southside Bulldogs |
153 |
Team |
Wild Cards |
154 |
Team |
Misfits |
155 |
Team |
Kyle |
156 |
Team |
Liberty Hillbillies |
157 |
Cameron |
Crawford |
158 |
Larry |
Stephens |
159 |
Gary |
Curtis |
160 |
Gayland |
Hamilton |
161 |
This is what I see. ????? I've gone back to your original and you are correct --team name is not a field there????? But "Team" is listed a the FirstName??? and TeamName as LastName???
With respect to what is being updated in the after update event of the combo, here is the SQL for the UPDATE. I modified a few records to Employed = 'No' to test the code. Here are 5 update statements used in my tests:
Code:
Update tblEmployees set teamID = 'MR', Employed = 'Yes' where empid = 196
Update tblEmployees set teamID = 'DD', Employed = 'Yes' where empid = 73
Update tblEmployees set teamID = 'MF', Employed = 'Yes' where empid = 83
Update tblEmployees set teamID = 'SB', Employed = 'Yes' where empid = 196
Update tblEmployees set teamID = 'BA', Employed = 'Yes' where empid = 77
I think that you should post the specs and clear description of requirements if I am going to be of any further help. Perhaps someone else has a better interpretation of your set up and can offer advice.