How to pass value from textbox to combobox?

[chleng]

Hi all.

I am new to access.

Does anyone know how to pass value from TextBox to ComboBox in VBA?

Controls in my form:
ItemCode textbox - user to key in the itemcode
SpeID1 textbox - LEFT(itemcode,2)
SpeID combobox - pass value from SpeID1 textbox to SpeID combobox
Desc textbox - Dlookup Desc from Species table using SpeID

The Desc will come out if I run the following code by choosing the value from the dropdown combobox without using the SpeID1 textbox
Code:

Private Sub SpeID_AfterUpdate()Desc = DLookup("Desc", "Species", "SpeID='" & SpeID & "'")End Sub
but what I want here is the user need not to choose the value from the SpeID Combobox and the SpeID and Desc will come out automatically after the user enter itemcode.



I try to use SpeID1_AfterUpdate() but no value appears at the Desc.

Anyone here kindly share your advice with me.

Thanks.

[jzwp11]

Welcome to the forum!

How is the combo box currently getting its data: table/query or value list?

[chleng]

Welcome to the forum!

How is the combo box currently getting its data: table/query or value list?

Hi, jzwp11.

The combo box is getting its data from table.

[jzwp11]

To get the value from the text box to the combo box, you have to add the value to the underlying table via an append query (or recordset) and then requery the combo box.

[chleng]

To get the value from the text box to the combo box, you have to add the value to the underlying table via an append query (or recordset) and then requery the combo box.

Do you mind to share with me the step by step? I am novice to MS Access

[jzwp11]

You'll have to provide a little more background as to what you are doing. It sounds like you have users who are selecting items from a combo box but on occassion they may have an item that is not in the combo box (and hence not in the underlying table). Instead of using a text box in conjunction with the combo box, you could just use the combo box and utilize its not in list event to open up a form where the user can enter the new item. The user would actually type the item in the combo box. Roger Carlson has an example database that does just that on his site. After you download the database, you would want to select Option 5 from the switchboard that opens when you open the database.