CODEWITHSUNDEEP
ms-accesseventscomboboxms-access-2010subform
Fredi Bineri
Fredi Bineri

Reputation: 1

Adding item from another table in ms -access combo box

I have a combo box with row source = suplier.suplierid, suplier.supliername. I am using a search-as-you-type code:

Option compare database

Dim ssouce1 as string

Private sub Form load()
    Ssouce1 = Replace(Me.Suplier.rowsource, ";" ,"")
End sub

Private sub suplier_change()
    Call filtercomboasyoutype(me.suplier, source, "supliername")
End sub

And if the item is not in the list, I want to add a new supplier (not the written item) but to select one from a reserved list where I keep the possible suppliers.

I want that if the item is not in list, a new list appears so I can search again with search as you type and to add selected item in my combobox.

Upvotes: 0

Views: 38

Answers (0)

Related Questions