Populating a textbox from a combobox when entering a new record

[Daisy509th]

I am Populating the Team Id textbox located on the Employee Add/Remove form from the Pick a team combobox located on main menu. The problem is that when I go to add a new record using the Employee Add/Remove form the Team ID textbox is no longer automaticaly fill in.

I am trying to find the vba code to put under on change of the Pick a Team combobox to fill this box in.
I currently am using a query to populate the Employee Add/Remove form

Thanks as always and sorry for this one because I am sure I missing something simple

[ranman256]

if you use a combo box, with 2 query fields [id],[name], then hide the ID field using col widths: 0;2
then the field gets the ID, and the user can see NAME. win/win in a single box.

if you want to do the 2 box thing, ...same settings, except show the combo box ID field and hide the name: 1;0
then in the combo AFTERUPDATE event, fill in the text box

sub cboBox_Afterupdate()
   txtName = cboBox.column(1)   'NOTE in vb, control columns start with zero. so col 2 in the property is cboBox.column(1)  in code.
end sub

or use a subform....fill in the ID box, the subform loads all the data for the ID.

[Daisy509th]

Attachment 33140
When Loading Second Form it is returning the value I am looking for.
Attachment 33141
The Second Form is Loaded and has the proper value in TeamID

Attachment 33142
Now when I go to add new record the value is no longer in TeamID.

I would like to be able to edit records but if necessary to add a new record without having the person know the TeamID. That box is not visible normally.

Thanks