<div>
is the form frmTimeReportingHeader open ?<br />
and is there an item selected in &nbsp;combo [cboProject]?
</div>


<div>
Answers/comments:<br />
<br />
is the form frmTimeReportingHeader open ? &nbsp; - &nbsp;YES.<br />
and is there an item selected in &nbsp;combo [cboProject]? &nbsp; - &nbsp;YES<br />
<br />
1. modify the form to join to the lookup table (usually with a left join to avoid loosing records). &nbsp;Then you can refer directly to the bound field &nbsp;rather then refering to it in the combo. &nbsp;- &nbsp;I UNDERSTAND<br />
&nbsp;2. add a hidden field to the form. &nbsp;In the AfterUpdate event of the combo, copy the .Column(1) property to the hidden field and reference the hidden field. &nbsp;- &nbsp;SOMETIMES IS DO THIS BUT IT ALWAYS FEELS &quot;SLOPPY&quot; WITH HIDDEN FIELDS ON A FORM. &nbsp;MAYBE IT'S JUST ME.
</div>


<div>
There are cases where Access thinks it is smarter than you. &nbsp;You can't win. &nbsp;This is especially true for reports. &nbsp;Since Access knows that a report cannot be updated, it rebuilds the query you so carefully constructed as the record source and ELIMINATES any field NOT bound to a control. &nbsp;Therefore, if you have a piece of code that does a calculation<br />
Me.somefield = Me.A + Me.B <br />
and A and B are not bound to controls, the calculation will fail because A and B are no longer part of the recordset.
</div>


<div>
Pat. &nbsp;Sometimes I know Access is smarter than I am. &nbsp;I am going to go ahead with:<br />
<br />
&quot;add a hidden field to the form. &nbsp;In the AfterUpdate event of the combo, copy the .Column(1) property to the hidden field and reference the hidden field.&quot;
</div>


<div>
I've been working with Access since the early 90's and no piece of software has EVER impressed me more. &nbsp;The foresight of the initial team was scary good. &nbsp;And then there's the little annoying things like this one. &nbsp;I'm sure this problem was introduced later by some lesser developer.
</div>


<div>
<div class="content wysiwyg-content">
I have a form that has a combobox. &nbsp;Then on a report I am trying to reference in the control source of a field on the report, that comboboxes 2nd column. &nbsp;(1st column after the key column)<br />
<br />
Here is what I'm using but I get a #Name? error in the field:<br />
<br />
=[Forms]![frmTimeReporting<wbr />Header]![c<wbr />boProject]<wbr />.[Column(1<wbr />)]
</div>
</div>


I have a form that has a combobox.  Then on a report I am trying to reference in the control source of a field on the report, that comboboxes 2nd column.  (1st column after the key column)

Here is what I'm using but I get a #Name? error in the field:

=[Forms]![frmTimeReportingHeader]![cboProject].[Column(1)]

Trying to use combobox column value on a report

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.