combo to text

[JaredNJames]

hi, i have a form which has a combo on it, and if the user enters data that isnt in the form they are given the option to add the item to the list.

if they choose yes the addition form is open.

is it possible to have the word the user just put into the combo box to display in the text box in the addition form.

so they only have to type it once.

thanks
jjames

 

[vodafrog]

if you are using the not in list event you can pass the NewData value to your new form's control: -

Private Sub Combo0_NotInList(NewData As String, Response As Integer)

DoCmd.openform "Addrecord"
Forms![Addrecord].[NewType] = NewData

End Sub

 

[JaredNJames]

thank you very much

why cant everyone else be this simple.

very impressed.
everywhere else has some complex explanation which means nothing.