Populate a text box from a combo box value

[dnf999]

Hi

I'm very new to Access and I need help on populating a text box based on a where clause from a combo box value.

i.e.
textbox.text = select field2 from table where field1 = field1.value (value from the combobox value)

So in summary. When I change the value in the combo box, the text box should have a value based on the combo box value where condition..

Thanks!

David

 

[MStef]

Hello David!

Look at "DemoComboTextA2000.mdb".
I think you need something like it. Open Form1 and try.
If you want to do this on your way, use DLOOKUP function.

 

[dnf999]

Thanks!

although the requirements have changed. How about if I have a text box and I want another text box to display the values based on that text box value search criteria.....

P.s where do you get sample access databases?

 

[GaryPanic]

type in sample on the search option it will lead you there