Combo Box Synchronizing issues

usafmeinweg · May 21st, 2010, 03:20 PM

SOLVED!!! Figured it out

Here is my layout.
Table Personnel
ID | FULL_NAME | Ops Init | TEAM

Table Team
ID | TEAM |

SIM
ID | INSTRUCTOR | TEAM | TRAINEE | DATE

Form Add
Combo box: Instructor, tmbox, Combo50
Text Box: Date, Start Time, End Time

tmbox and Combo50 are already synchronized. When I enter all the data into the form and save, the Team ID is placed into the TEAM column. I want the TEAM name added not the ID.

When I change the the bound column of my tmbox, now my combo boxes aren't synchronized, but I get the correct data saved to the SIM table.

Any help would greatly be appreciated.

Here is the code to my tmbox

Code:

Private Sub tmbox_AfterUpdate()
    Me.Combo50.RowSource = "SELECT FULL_NAME & ' (' & [Ops Init] & ')' " & _
                            " FROM Team INNER JOIN Personnel ON Team.TEAM = Personnel.TEAM " & _
                            " WHERE Team.ID = tmbox " & _
                            " ORDER BY Personnel.FULL_NAME"
    Me.Combo50 = Me.Combo50.ItemData(0)
 
End Sub