load a textbox from selected value from another form

[ost3z]

hi everybody i have employee form to insert employee information one of its text box on click another form open of schools name where i can select the school work how can i pass selected school name to the main form

 

[pr2-eugin]

Change the TextBox in the main form to a ComboBox and have its RowSource to be the SchoolForm table. That is what you need.

 

[ost3z]

thanks for your answer i know that way but suppose i have 100 school name is it to do like i ask for ? can it be done or not ?