Write calculated control to table

[Ernie]

Table INV has three fields: ID, TYPE, IDTYPE. Form INV-FORM is
bound to table INV. ID is autogenerated and TYPE is populated from a
combo-box on the form. ORDERID is a calculated control that
concatenates ID and TYPE. When the IDTYPE field is populated, I would
like to be able to 'write' this value into the INV table in field
IDTYPE.

ID= 001
TYPE = ABC
ORDERID = 001ABC

I want to populate the IDTYPE in the table with the ORDERID result
(001ABC)

How can I do that?

 

[ruralguy via AccessMonster.com]

I would put them together in the AfterUpdate event of the ComboBox.
Me.OrderID = Me.ID & Me.[Type]

BTW, "Type" is a reserved word in Access. Here's some links.

http://support.microsoft.com/?id=286335
http://support.microsoft.com/?id=321266
http://support.microsoft.com/?id=826763