Combobox Question

[Kriis]

Is this possible?

I want to have a combo box with a listing of names from a table. Once you choose a name, a textbox in the same form (not subform) populates with the corresponding ID.

Thanks.

 

[bonekrusher]

yes it is. if you post you DB I'll show you how to do it....

Bones

 

[Kriis]

Post my database?

 

[Kriis]

If this can be done, can someone please tell me how?

My form name is called test.

Combo0 is a list of Oil_Names from the Oil table

I want the text box called testbox to display the Oil ID, after I choose the Oil Name from Combo0.

Do I create a query for the record source of the test form? I tried that and then I tried the following code for the combobox

Private Sub Combo0_AfterUpdate()
[test].Requery

It didn't work.

 

[bonekrusher]

try this (see attached)