Hi, people!

I'm trying to select data in a datacombo and automatically updating a text box.
I don't know how to do that only using the datacombo and textbox properties, so I'm trying to create a module.
Have added the following code to the "Change" event of my datacombo:
==================
Dim MyDb As Database
Dim Myset As Recordset
Set MyDb = "<my db name>"
Set Myset = MyDb.OpenRecordset("select Description from [My table] where COD = " & [<my datacombo name])
===================
How can I connect the result of this query to my text box?
I’m starting with VB now and I don’t even know if I am in the right direction.

Thanks in advance,
Roselene