Desperate...combo box fill other fields

[Dawnit]

Hi! I tried HarrisonA's suggestion to Thread181-22319, but have a problem.

I have two tables: "All Records" and "Record Descriptions & Retentions"
I have a form with a combo box (includes 4 fields from the Descriptions table but only column 1 shows)

The Row Source property is: SELECT [Record Descriptions & Retentions].[Contents], [Record Descriptions & Retentions].[DeptRet], [Record Descriptions & Retentions].[WrhseRet], [Record Descriptions & Retentions].[TotalRetention] FROM [Record Descriptions & Retentions]

In the combo box AfterUpdate property, I typed: =[All Records]![DeptRet]=[ContentsComboBox].Column(2)

ERROR MESSAGE: "The expression AfterUpdate you entered as the event property setting produced the following error: The object doesn't contain the Automation object 'All Records.'."

Where am I going wrong?

What I want to do is when I make a combo box selection, I want info that corresponds to that selection to fill a different field in my form and ultimately be stored in a field in the main All Records table.

 

[ruthcali]

You are close,

in the combo box AfterUpdate property, choose [event procedure]. then click on the AfterUpdate line and choose the 3 dots (...) that brings you into the code module.

is the field DepRet in the rowsource of your form? if so, type
me.deptret=[ContentsComboBox].Column(2)

ruth.jonkman@wcom.com