Update record base on bound text box?

[Oded Dror]

Hi there,

I'm using Access 2002 on Windows XP Pro.

I have two tables:
one tblPartLookup
with two columns PartID and PartDescription

two tblUnits
with ID, UnitDescription, PartID and PartDescription

Now! I created a form base on tblUnits
I place a Combobox base on lookup fields from tblPartLookup and I bound this
two cloumns.
I created a bound text box base on the Combobox (ControlSource
=[CboName].Columns(1))
everythings works fine when I'm clicking on the combobox PartID the text box
show the right PartDescription
But when I'm open the tblUnits I see that only the PartID was update, the
PartDescription is empty?

My question is how to make the bound textbox value uptade the table ?

P.S. I try me.txtboxName.Requery (AfterUpdate but with no results)
also I can create a DLookup qry base on PartID but I'm recieving only the
first record all the time?

Thanks,

Oded Dror
Email: (e-mail address removed)

 

[Dan Artuso]

Hi,
You already have the PartDescription in tblPartLookup.
There is no need to store it elsewhere.
In relational databases, you store data once and only once.
When you need to display it, you simply use a query that pulls the info.