Textbox update

  • Thread starter Thread starter Oded Dror
  • Start date Start date
O

Oded Dror

Hi there,

I'm using Access2002 and WinXP 2000 Pro.

I have a form with Combobox base on query like PartID and PartDescription
and
the combobox show me the partID and I have textbox base on the combobox
that show me the PartDescription (RowSource: =[myCboName].Column(1) )

Now every time when I open the combobox looking for partID the textbox will
show the proper description for that
but when I create a new record and look at the table I see that Only the
Combobox (PartID) has been update.
The text box (and I have PartDescription field in my table) has not been
updated.

My question is : How to update a record in the table (textbox base on
combobox lookup)

Thanks,

Oded Dror

Email: (e-mail address removed)
 
If I have understood you correctly, you are selecting a PartID in the
ComboBox and the TextBox shows the PartDescription that is in column 1 of
the ComboBox. That if you add a new record then the TextBox does not show
the new decription.

What you need to do is requery the text box after adding a new record,
Me.PartDescription.Requery.
Regards
 
Back
Top