Making combo box Editable

[mapat]

Hello everyone,

I have a combo box that looks at some values on a table (let's say "optionA", and "optionB". How can I make this box editable by the users on a specific record? Meaning if the user chooses "optionA" on a certain record, I want to be able to add " whatever" after "optionA", so I would end up with
"optionA whatever" on that record.

Please, note that I do not intend to change the static values on the table (in this case "optionA" would be this value.)

Thank you very much

 

[John Big Booty]

Do you mean something like in the attached?

 

[mapat]

Do you mean something like in the attached?

Not really, I want the user to choose the option from the combo box, and right after the selection text ends (inside the same combo box), I want them to be able to type in whatever they want in addition to the selection they choose.

Thanks

 

[Vassago]

You would have to use VBA to set the LimitToList value based on which option is selected by the combo. Try placing something like this in the AfterUpdate event of the combo box you are trying to do this too:

    If left(Me!cmb_options,7) = "OptionA" Then
        Me!cmb_options.LimitToList = False
        Else
        Me!cmb_options.LimitToList = True
    End If