Populating a Textbox

[Daisy509th]

The is a double post. I messed up and posted this twice and cant figure out how to delete this.



I am truly sorry.




Attachment 33130Attachment 33131

I have a query that populates the Team Member Add/Remove form. I want to have the Team ID textbox populated automatically when adding a new record. I want to popluate team id from the combobox on the main menu 'Pick a Team' .

I am sure this is done with VBA but I cant seem to figure it out.

Thanks for any and all help

[isladogs]

When the info is first entered save it as a variable (or a tempvar)
Then refer to that veriablee to populate the value elsewhere

e.g. in first form
Dim strTeam As String
strTeam - Me.TeamID

in second form
Me.txtTeamID = strTeam

A request for future posts. Could you crop your images to just use the relevant part
Then you can omit the nav pane & database window & just show a larger version of the actual form(s)